Loading

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

0 Responses to “DESCRIPTIVE FLEXFIELD SETUP DETAILS – QUERY R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.