Descriptive Flex Fields :-
Query to see all the Descriptive Flex Fields :-
SELECT
d.application_name,
a.descriptive_flexfield_name, a.application_table_name,
b.descriptive_flex_context_code,
c.application_column_name, c.end_user_column_name
FROM
apps.FND_DESCRIPTIVE_FLEXS a,
apps.FND_DESCR_FLEX_CONTEXTS b,
apps.FND_DESCR_FLEX_COLUMN_USAGES c,
apps.FND_APPLICATION_TL d
WHERE b.descriptive_flexfield_name = a.descriptive_flexfield_name
AND b.application_id = a.application_id
AND c.descriptive_flexfield_name = b.descriptive_flexfield_name
AND c.application_id = b.application_id
AND c.descriptive_flex_context_code = b.descriptive_flex_context_code
AND d.application_id = a.application_id
AND c.enabled_flag ='Y'
AND b.enabled_flag ='Y'
AND a.descriptive_flexfield_name IN(
'GL_JE_CATEGORIES',
'HR_LOCATIONS',
'MTL_SYSTEM_ITEMS',
'AP_BANK_ACCOUNTS',
'AP_INVOICE_DISTRIBUTIONS',
'PO_ASL_ATTRIBUTES',
'PO_DISTRIBUTIONS',
'MRP_FORECAST_DATES',
'OE_LINE_ATTRIBUTES',
'PO_HEADERS',
'PO_VENDORS',
'RA_CUSTOMER_TRX_LINES',
'RA_SITE_USES_HZ',
'RA_CUSTOMER_TRX')
/
Query to see the Description/Context of the Descriptive Flex Fields :-
SELECT
descriptive_flex_context_code , application_column_name , end_user_column_name
FROM
FND_DESCR_FLEX_COL_USAGE_VL
WHERE
descriptive_flex_context_code like '%INTERCOMPANY%'
List of Interface Line Attribute values when the INTERFACE_LINE_CONTEXT is "ORDER ENTRY" :-
Interface_Line_Attribute1 - Order Number
Interface_Line_Attribute2 - Order Type
Interface_Line_Attribute3 - Delivery
Interface_Line_Attribute4 - WayBill
Interface_Line_Attribute5 - Count
Interface_Line_Attribute6 - Line ID
Interface_Line_Attribute7 - Picking Line ID
Interface_Line_Attribute8 - Warehouse
Interface_Line_Attribute9 - Price Adjustment ID
Interface_Line_Attribute10 - Bill of Lading
Interface_Line_Attribute11 - Customer Item Part
Interface_Line_Attribute12 - Shipment Number
Interface_Line_Attribute13 - Option Number
Query to see all the Descriptive Flex Fields :-
SELECT
d.application_name,
a.descriptive_flexfield_name, a.application_table_name,
b.descriptive_flex_context_code,
c.application_column_name, c.end_user_column_name
FROM
apps.FND_DESCRIPTIVE_FLEXS a,
apps.FND_DESCR_FLEX_CONTEXTS b,
apps.FND_DESCR_FLEX_COLUMN_USAGES c,
apps.FND_APPLICATION_TL d
WHERE b.descriptive_flexfield_name = a.descriptive_flexfield_name
AND b.application_id = a.application_id
AND c.descriptive_flexfield_name = b.descriptive_flexfield_name
AND c.application_id = b.application_id
AND c.descriptive_flex_context_code = b.descriptive_flex_context_code
AND d.application_id = a.application_id
AND c.enabled_flag ='Y'
AND b.enabled_flag ='Y'
AND a.descriptive_flexfield_name IN(
'GL_JE_CATEGORIES',
'HR_LOCATIONS',
'MTL_SYSTEM_ITEMS',
'AP_BANK_ACCOUNTS',
'AP_INVOICE_DISTRIBUTIONS',
'PO_ASL_ATTRIBUTES',
'PO_DISTRIBUTIONS',
'MRP_FORECAST_DATES',
'OE_LINE_ATTRIBUTES',
'PO_HEADERS',
'PO_VENDORS',
'RA_CUSTOMER_TRX_LINES',
'RA_SITE_USES_HZ',
'RA_CUSTOMER_TRX')
/
Query to see the Description/Context of the Descriptive Flex Fields :-
SELECT
descriptive_flex_context_code , application_column_name , end_user_column_name
FROM
FND_DESCR_FLEX_COL_USAGE_VL
WHERE
descriptive_flex_context_code like '%INTERCOMPANY%'
List of Interface Line Attribute values when the INTERFACE_LINE_CONTEXT is "ORDER ENTRY" :-
Interface_Line_Attribute1 - Order Number
Interface_Line_Attribute2 - Order Type
Interface_Line_Attribute3 - Delivery
Interface_Line_Attribute4 - WayBill
Interface_Line_Attribute5 - Count
Interface_Line_Attribute6 - Line ID
Interface_Line_Attribute7 - Picking Line ID
Interface_Line_Attribute8 - Warehouse
Interface_Line_Attribute9 - Price Adjustment ID
Interface_Line_Attribute10 - Bill of Lading
Interface_Line_Attribute11 - Customer Item Part
Interface_Line_Attribute12 - Shipment Number
Interface_Line_Attribute13 - Option Number
Comments