Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT CO.NAME
, COCL.NAME
, COCL.SEQUENCE_NUMBER
, COCL.PREFIX
, COCL.SUFFIX
, COCL.DB_FUNCTION1
, COLO1.MEANING
, COLO2.MEANING
, COLO3.MEANING
, COLO4.MEANING
, DECODE(COCL.DB_OBJECT_NAME1
, 'SO_LINES_V'
, DE1.DESCRIPTIVE_FLEX_CONTEXT_CODE||':'||DE1.END_USER_COLUMN_NAME
, NVL(AT1.NAME
, COLO8.MEANING))
, DECODE(COCL.DB_OBJECT_NAME2
, 'SO_LINES_V'
, DE2.DESCRIPTIVE_FLEX_CONTEXT_CODE||':'||DE2.END_USER_COLUMN_NAME
, NVL(AT2.NAME
, NVL(COLO9.MEANING
, COCL.ATTRIBUTE_CODE2)))
, COLO5.MEANING
, COLO6.MEANING
, COLO7.MEANING
, COCL.CONSTRAINT_ID
, COCL.CLAUSE_ID
, COCL.FUNCTION1
, COCL.FUNCTION2
, COCL.DB_OBJECT_NAME1
, COCL.DB_OBJECT_NAME2
, COCL.ATTRIBUTE_CODE1
, COCL.ATTRIBUTE_CODE2
, COCL.COMPARATOR
, COCL.OPERATOR
, COCL.ACTION_IF_NULL
, '_DF:BOM:CZ_CONSTRAINT_CLAUSES:COCL'
, COCL.CREATION_DATE
, COCL.CREATED_BY
, COCL.LAST_UPDATE_DATE
, COCL.LAST_UPDATED_BY
FROM FND_DESCR_FLEX_COLUMN_USAGES DE1
, FND_DESCR_FLEX_COLUMN_USAGES DE2
, AK_ATTRIBUTES_VL AT1
, AK_ATTRIBUTES_VL AT2
, FND_COMMON_LOOKUPS COLO1
, FND_COMMON_LOOKUPS COLO2
, FND_COMMON_LOOKUPS COLO3
, FND_COMMON_LOOKUPS COLO4
, FND_COMMON_LOOKUPS COLO5
, FND_COMMON_LOOKUPS COLO6
, FND_COMMON_LOOKUPS COLO7
, FND_COMMON_LOOKUPS COLO8
, FND_COMMON_LOOKUPS COLO9
, CZ_CONSTRAINTS CO
, CZ_CONSTRAINT_CLAUSES COCL
WHERE COCL.CONSTRAINT_ID = CO.CONSTRAINT_ID
AND COCL.FUNCTION1 = COLO1.LOOKUP_CODE
AND COLO1.LOOKUP_TYPE = 'CZ_FUNCTIONS'
AND COLO1.APPLICATION_ID = 702
AND COCL.FUNCTION2 = COLO2.LOOKUP_CODE(+)
AND COLO2.LOOKUP_TYPE(+) = 'CZ_FUNCTIONS'
AND COLO2.APPLICATION_ID(+) = 702
AND COCL.DB_OBJECT_NAME1 = COLO3.LOOKUP_CODE(+)
AND COLO3.LOOKUP_TYPE(+) = 'CZ_DB_OBJECT_TYPES'
AND COLO3.APPLICATION_ID(+) = 702
AND COCL.DB_OBJECT_NAME2 = COLO4.LOOKUP_CODE(+)
AND COLO4.LOOKUP_TYPE(+) = 'CZ_DB_OBJECT_TYPES'
AND COLO4.APPLICATION_ID(+) = 702
AND COCL.COMPARATOR = COLO5.LOOKUP_CODE
AND COLO5.LOOKUP_TYPE = 'CZ_COMPARATORS'
AND COLO5.APPLICATION_ID = 702
AND COCL.OPERATOR = COLO6.LOOKUP_CODE(+)
AND COLO6.LOOKUP_TYPE(+) = 'CZ_OPERATORS'
AND COLO6.APPLICATION_ID(+) = 702
AND COCL.ACTION_IF_NULL = COLO7.LOOKUP_CODE(+)
AND COLO7.LOOKUP_TYPE(+) = 'CZ_ACTION_IF_NULL'
AND COLO7.APPLICATION_ID(+) = 702
AND COCL.ATTRIBUTE_CODE1 = COLO8.LOOKUP_CODE(+)
AND COLO8.LOOKUP_TYPE(+) = 'CZ_ATTRIBUTES'
AND COLO8.APPLICATION_ID(+) = 702
AND COCL.ATTRIBUTE_CODE2 = COLO9.LOOKUP_CODE(+)
AND COLO9.LOOKUP_TYPE(+) = 'CZ_ATTRIBUTES'
AND COLO9.APPLICATION_ID(+) = 702
AND DE1.APPLICATION_ID(+) = 300
AND DE1.DESCRIPTIVE_FLEXFIELD_NAME(+) = 'SO_LINES'
AND DE1.DESCRIPTIVE_FLEX_CONTEXT_CODE(+) = DECODE(COCL.DB_OBJECT_NAME1
, 'SO_LINES_V'
, SUBSTR(COCL.ATTRIBUTE_CODE1
, 1
, INSTR(COCL.ATTRIBUTE_CODE1
, ':')-1)
, '-99')
AND DE1.APPLICATION_COLUMN_NAME(+) = DECODE(COCL.DB_OBJECT_NAME1
, 'SO_LINES_V'
, SUBSTR(COCL.ATTRIBUTE_CODE1
, INSTR(COCL.ATTRIBUTE_CODE1
, ':')+1)
, '-99')
AND AT1.ATTRIBUTE_APPLICATION_ID(+) = 702
AND AT1.ATTRIBUTE_CODE(+) = COCL.ATTRIBUTE_CODE1
AND DE2.APPLICATION_ID(+) = 300
AND DE2.DESCRIPTIVE_FLEXFIELD_NAME(+) = 'SO_LINES'
AND DE2.DESCRIPTIVE_FLEX_CONTEXT_CODE(+) = DECODE(COCL.DB_OBJECT_NAME2
, 'SO_LINES_V'
, SUBSTR(COCL.ATTRIBUTE_CODE2
, 1
, INSTR(COCL.ATTRIBUTE_CODE2
, ':')-1)
, '-99')
AND DE2.APPLICATION_COLUMN_NAME(+) = DECODE(COCL.DB_OBJECT_NAME2
, 'SO_LINES_V'
, SUBSTR(COCL.ATTRIBUTE_CODE2
, INSTR(COCL.ATTRIBUTE_CODE2
, ':')+1)
, '-99')
AND AT2.ATTRIBUTE_APPLICATION_ID(+) = 702
AND AT2.ATTRIBUTE_CODE(+) = COCL.ATTRIBUTE_CODE2 WITH READ ONLY