View: CZ_CONSTRAINT_CLAUSES_V

View Text

SELECT C.ROWID ROW_ID
, C.CLAUSE_ID CLAUSE_ID
, C.CONSTRAINT_ID CONSTRAINT_ID
, C.LAST_UPDATE_DATE LAST_UPDATE_DATE
, C.LAST_UPDATED_BY LAST_UPDATED_BY
, C.CREATION_DATE CREATION_DATE
, C.CREATED_BY CREATED_BY
, C.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, C.NAME NAME
, C.SEQUENCE_NUMBER SEQUENCE_NUMBER
, C.ACTION_IF_NULL ACTION_IF_NULL
, C.PREFIX PREFIX
, FCL1.MEANING FN1_NAME
, C.FUNCTION1 FUNCTION1
, C.DB_FUNCTION1 DB_FUNCTION1
, DECODE(DB_OBJECT_NAME1
, 'SO_LINES_V'
, DESC1.DESCRIPTIVE_FLEX_CONTEXT_CODE||':'|| DESC1.END_USER_COLUMN_NAME
, NVL(AK1.NAME
, FCLN1.MEANING)) ATTRIBUTE_NAME1
, DECODE(DB_OBJECT_NAME2
, 'SO_LINES_V'
, DESC2.DESCRIPTIVE_FLEX_CONTEXT_CODE||':'|| DESC2.END_USER_COLUMN_NAME
, NVL(AK2.NAME
, NVL(FCLN2.MEANING
, ATTRIBUTE_CODE2))) ATTRIBUTE_NAME2
, DECODE(DB_OBJECT_NAME1
, 'SO_HEADER_V'
, 'VARCHAR2'
, 'SO_LINES_V'
, DECODE(VAL1.FORMAT_TYPE
, 'C'
, 'VARCHAR2'
, 'NUMBER')
, NVL(AK1.DATA_TYPE
, 'VARCHAR2')) ATTRIBUTE_TYPE1
, C.ATTRIBUTE_CODE1 ATTRIBUTE_CODE1
, FCLC.MEANING COMPARATOR_NAME
, C.COMPARATOR COMPARATOR
, FCL2.MEANING FN2_NAME
, C.FUNCTION2 FUNCTION2
, DECODE(DB_OBJECT_NAME2
, 'SO_HEADER_V'
, 'VARCHAR2'
, 'SO_LINES_V'
, DECODE(VAL2.FORMAT_TYPE
, 'C'
, 'VARCHAR2'
, 'NUMBER')
, DECODE(C.COMPARATOR
, 'IN'
, LOWER(C.FUNCTION2)
, 'NOT IN'
, LOWER(C.FUNCTION2)
, DECODE(C.FUNCTION2
, NULL
, NULL
, 'LIST_CHAR'
, 'VARCHAR2'
, 'LIST_NUM'
, 'NUMBER'
, 'LIT_CHAR'
, 'VARCHAR2'
, 'LIT_NUM'
, 'NUMBER'
, NVL(AK2.DATA_TYPE
, 'VARCHAR2')))) ATTRIBUTE_TYPE2
, C.ATTRIBUTE_CODE2 ATTRIBUTE_CODE2
, C.SUFFIX SUFFIX
, FCLO.MEANING OPERATOR_NAME
, C.OPERATOR OPERATOR
, DB_OBJECT_NAME1 DB_OBJECT_NAME1
, DB_OBJECT_NAME2 DB_OBJECT_NAME2
, FCLDBO1.MEANING DB_TXT_OBJ_NAME1
, FCLDBO2.MEANING DB_TXT_OBJ_NAME2
, C.ATTRIBUTE_CATEGORY
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
FROM FND_COMMON_LOOKUPS FCL1
, FND_COMMON_LOOKUPS FCL2
, FND_FLEX_VALUE_SETS VAL2
, FND_FLEX_VALUE_SETS VAL1
, FND_DESCR_FLEX_COLUMN_USAGES DESC2
, FND_DESCR_FLEX_COLUMN_USAGES DESC1
, FND_COMMON_LOOKUPS FCLDBO1
, FND_COMMON_LOOKUPS FCLDBO2
, FND_COMMON_LOOKUPS FCLO
, FND_COMMON_LOOKUPS FCLC
, FND_COMMON_LOOKUPS FCLN1
, FND_COMMON_LOOKUPS FCLN2
, AK_OBJECTS_VL AOV1
, AK_OBJECTS_VL AOV2
, AK_OBJECT_ATTRIBUTES AOA1
, AK_OBJECT_ATTRIBUTES AOA2
, AK_ATTRIBUTES_VL AK1
, AK_ATTRIBUTES_VL AK2
, CZ_CONSTRAINT_CLAUSES C
WHERE AK1.ATTRIBUTE_CODE (+) = C.ATTRIBUTE_CODE1
AND AK2.ATTRIBUTE_CODE(+) =DECODE(C.DB_OBJECT_NAME2
, 'MTL_SYSTEM_ITEMS_KFV'
, DECODE(C.ATTRIBUTE_CODE2
, 'ITEM_NAME'
, ''
, C.ATTRIBUTE_CODE2)
, '')
AND AK1.ATTRIBUTE_APPLICATION_ID (+) = 702
AND AK2.ATTRIBUTE_APPLICATION_ID (+) = 702
AND AOA1.ATTRIBUTE_CODE (+) = AK1.ATTRIBUTE_CODE
AND AOA2.ATTRIBUTE_CODE (+) = AK2.ATTRIBUTE_CODE
AND AOA1.ATTRIBUTE_APPLICATION_ID (+) = 702
AND AOA2.ATTRIBUTE_APPLICATION_ID (+) = 702
AND DESC1.APPLICATION_ID (+) = 300
AND DESC1.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'SO_LINES'
AND DESC1.DESCRIPTIVE_FLEX_CONTEXT_CODE(+)=DECODE(C.DB_OBJECT_NAME1
, 'SO_LINES_V'
, SUBSTR(C.ATTRIBUTE_CODE1
, 1
, INSTR(C.ATTRIBUTE_CODE1
, ':')-1)
, '-99')
AND DESC1.APPLICATION_COLUMN_NAME (+) = DECODE(C.DB_OBJECT_NAME1
, 'SO_LINES_V'
, SUBSTR(C.ATTRIBUTE_CODE1
, INSTR(C.ATTRIBUTE_CODE1
, ':')+1)
, '-99')
AND VAL1.FLEX_VALUE_SET_ID (+) = DESC1.FLEX_VALUE_SET_ID
AND DESC2.APPLICATION_ID (+) = 300
AND DESC2.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'SO_LINES'
AND DESC2.DESCRIPTIVE_FLEX_CONTEXT_CODE(+)=DECODE(C.DB_OBJECT_NAME2
, 'SO_LINES_V'
, SUBSTR(C.ATTRIBUTE_CODE2
, 1
, INSTR(C.ATTRIBUTE_CODE2
, ':')-1)
, '-99')
AND DESC2.APPLICATION_COLUMN_NAME (+) = DECODE(C.DB_OBJECT_NAME2
, 'SO_LINES_V'
, SUBSTR(C.ATTRIBUTE_CODE2
, INSTR(C.ATTRIBUTE_CODE2
, ':')+1)
, '-99')
AND VAL2.FLEX_VALUE_SET_ID (+) = DESC2.FLEX_VALUE_SET_ID
AND FCLDBO1.APPLICATION_ID(+)=702
AND FCLDBO2.APPLICATION_ID(+)=702
AND FCLDBO1.LOOKUP_TYPE(+)='CZ_DB_OBJECT_TYPES'
AND FCLDBO2.LOOKUP_TYPE(+)='CZ_DB_OBJECT_TYPES'
AND FCLDBO1.LOOKUP_CODE(+) = DB_OBJECT_NAME1
AND FCLDBO2.LOOKUP_CODE(+)=DB_OBJECT_NAME2
AND FCLN1.APPLICATION_ID(+)=702
AND FCLN2.APPLICATION_ID(+)=702
AND FCLN1.LOOKUP_TYPE(+)='CZ_ATTRIBUTES'
AND FCLN2.LOOKUP_TYPE(+)='CZ_ATTRIBUTES'
AND FCLN1.LOOKUP_CODE(+) = ATTRIBUTE_CODE1
AND FCLN2.LOOKUP_CODE(+)= ATTRIBUTE_CODE2
AND FCL1.LOOKUP_TYPE = 'CZ_FUNCTIONS'
AND FCL2.LOOKUP_TYPE (+) = 'CZ_FUNCTIONS'
AND FCL1.LOOKUP_CODE = C.FUNCTION1
AND FCL2.LOOKUP_CODE (+) = DECODE(C.FUNCTION2
, 'LIST_NUM'
, 'LIST_LIT'
, 'LIST_CHAR'
, 'LIST_LIT'
, C.FUNCTION2)
AND FCL1.APPLICATION_ID = 702
AND FCL2.APPLICATION_ID (+)= 702
AND FCLO.APPLICATION_ID(+) = 702
AND FCLC.APPLICATION_ID = 702
AND FCLO.LOOKUP_TYPE(+) = 'CZ_OPERATORS'
AND FCLC.LOOKUP_TYPE = 'CZ_COMPARATORS'
AND FCLO.LOOKUP_CODE(+) = C.OPERATOR
AND FCLC.LOOKUP_CODE = C.COMPARATOR
AND AOV1.APPLICATION_ID(+) = 702
AND AOV2.APPLICATION_ID(+) = 702
AND AOV1.DATABASE_OBJECT_NAME(+) = C.DB_OBJECT_NAME1
AND AOV2.DATABASE_OBJECT_NAME(+) = C.DB_OBJECT_NAME2

Columns