Thursday, May 19, 2011
DESCRIPTIVE FLEXFIELD SETUP DETAILS – QUERY R12
In this post, I provided a query which helps to gather the details related to AR Invoice Descriptive Flexfield Setup.
1. Transaction Information
2. Invoice Transaction Flexfield
3. Invoice Line Information
4. Line Transaction Flexfield
Query 1: DECRIPTIVE FLEXFIELD REGISTRATION DETAILS
SELECT title
, application_table_name
, descriptive_flexfield_name
, context_column_name
FROM fnd_descriptive_flexs_vl
WHERE title IN
('Transaction Information',
'Invoice Transaction Flexfield',
'Invoice Line Information',
'Line Transaction Flexfield'
)
Query2: DECRIPTIVE FLEXFIELD CONTEXT DETAILS
SELECT descriptive_flex_context_code
, descriptive_flex_context_name
, description
, enabled_flag
, application_id
, descriptive_flexfield_name
, global_flag
FROM fnd_descr_flex_contexts_vl
WHERE descriptive_flexfield_name = 'RA_CUSTOMER_TRX'
Query3: DECRIPTIVE FLEXFIELD CONTEXT SEGMENT DETAILS
-- Line Transaction FlexField –
SELECT descriptive_flex_context_code INTERFACE_LINE_CONTEXT, end_user_column_name description,
application_column_name column_used,
required_flag required
FROM fnd_descr_flex_col_usage_vl
WHERE 1 = 1
AND (descriptive_flexfield_name LIKE 'RA_INTERFACE_LINES')
AND (descriptive_flex_context_code = 'ORDER ENTRY')
ORDER BY column_seq_num
-- Invoice Transaction FlexField –
SELECT descriptive_flex_context_code INTERFACE_HEADER_CONTEXT, end_user_column_name description,
application_column_name column_used,
required_flag required
FROM fnd_descr_flex_col_usage_vl
WHERE 1 = 1
AND (descriptive_flexfield_name LIKE 'RA_INTERFACE_HEADER')
AND (descriptive_flex_context_code = 'ORDER ENTRY')
ORDER BY column_seq_num
-- Invoice Descriptive FlexField –
SELECT descriptive_flex_context_code HEADER_ATTRIBUTE_CATEGORY, end_user_column_name description,
application_column_name column_used,
required_flag required
FROM fnd_descr_flex_col_usage_vl
WHERE 1 = 1
AND (descriptive_flexfield_name LIKE 'RA_CUSTOMER_TRX')
AND (descriptive_flex_context_code = 'ORDER ENTRY')
ORDER BY column_seq_num
-- Invoice LINE Descriptive FlexField –
SELECT descriptive_flex_context_code ATTRIBUTE_CATEGORY, end_user_column_name description,
application_column_name column_used,
required_flag required
FROM fnd_descr_flex_col_usage_vl
WHERE 1 = 1
AND (descriptive_flexfield_name LIKE 'RA_CUSTOMER_TRX_LINES')
AND (descriptive_flex_context_code = 'ORDER ENTRY')
ORDER BY column_seq_num
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “DESCRIPTIVE FLEXFIELD SETUP DETAILS – QUERY R12”
Post a Comment