Thursday, November 2, 2017

Query to know the Attributes(DFF Fields) Actual Column Names in Oracle tables

SELECT b.APPLICATION_TABLE_NAME,
       b.DESCRIPTIVE_FLEXFIELD_NAME,
       a.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       a.APPLICATION_COLUMN_NAME,
       a.END_USER_COLUMN_NAME
  FROM FND_DESCR_FLEX_COLUMN_USAGES a,
       FND_DESCRIPTIVE_FLEXS_vl b
 WHERE   
b.APPLICATION_TABLE_NAME IN (UPPER ('<table_name>'))       
AND b.DESCRIPTIVE_FLEXFIELD_NAME = a.DESCRIPTIVE_FLEXFIELD_NAME
AND b.APPLICATION_ID = a.APPLICATION_ID

No comments:

Post a Comment

Oracle EBS R12 – Query to View Consolidated Invoice Details with Individual Transactions

SELECT     hp.party_name                  AS customer_name,     aca.account_number             AS customer_account,     hci.cons_billing_num...