View: CZ_CONSTRAINT_ASSIGNMENTS_V

View Text

SELECT CA.ROWID
, CA.ASSIGNMENT_ID
, CA.CONSTRAINT_ID
, CA.CONSTRAINT_GROUP
, FCL_GROUP.MEANING
, CD.NAME
, CD.CONSTRAINT_TYPE
, FCL_TYPE.MEANING
, CA.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.BOM_ITEM_TYPE
, CA.ORGANIZATION_ID
, CA.SYSTEM_TYPE_CODE
, FCL.MEANING
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_LOGIN
, CA.SEQUENCE_NUMBER
, CA.EVALUATE_ON_TRUE
, CA.OPTIMIZE_FLAG
, CA.OPTIMIZE_EXPRESSION
, CZDVCONS.ASSIGNMENT_RENAME_EXPRESSION(CA.OPTIMIZE_EXPRESSION)
, CA.EFFECTIVITY_DATE
, CA.DISABLE_DATE
, CA.ECN_CODE
, CA.AUTOSELECTION_TYPE
, CA.SCOPE
, CA.MESSAGE_LEVEL
, CA.REVENUE_FLAG
, CA.PRICE_FLAG
, CA.AUTOSELECT_ON_BOOK
, CA.ATTRIBUTE_CATEGORY
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
FROM CZ_CONSTRAINTS CD
, MTL_SYSTEM_ITEMS_KFV MSI
, FND_COMMON_LOOKUPS FCL
, FND_COMMON_LOOKUPS FCL_GROUP
, FND_COMMON_LOOKUPS FCL_TYPE
, CZ_CONSTRAINT_ASSIGNMENTS CA
WHERE CD.CONSTRAINT_ID = CA.CONSTRAINT_ID
AND MSI.INVENTORY_ITEM_ID (+) = CA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = CA.ORGANIZATION_ID
AND FCL.LOOKUP_CODE(+) = CA.SYSTEM_TYPE_CODE
AND FCL.APPLICATION_ID(+) = 702
AND FCL.LOOKUP_TYPE (+) = 'CZ_SYSTEM_TYPES'
AND FCL_GROUP.APPLICATION_ID(+)=702
AND FCL_GROUP.LOOKUP_TYPE(+)='CZ_CONSTRAINT_GROUPS'
AND FCL_GROUP.LOOKUP_CODE(+)=CA.CONSTRAINT_GROUP
AND FCL_TYPE.APPLICATION_ID=702
AND FCL_TYPE.LOOKUP_TYPE='CZ_CONSTRAINT_TYPES'
AND FCL_TYPE.LOOKUP_CODE=CD.CONSTRAINT_TYPE

Columns