View: CZ_ERRORS_V

View Text

SELECT CZ.ERROR_ID
, CZ.ROWID ROW_ID
, CC.NAME CONSTRAINT_NAME
, CA.CONSTRAINT_GROUP
, FND2.MEANING CONSTRAINT_GROUP_NAME
, CA.AUTOSELECTION_TYPE
, CC.CONSTRAINT_TYPE
, FND1.MEANING CONSTRAINT_TYPE_NAME
, CZ.LAST_UPDATE_DATE
, CZ.LAST_UPDATED_BY
, CZ.CREATION_DATE
, CZ.CREATED_BY
, CZ.LAST_UPDATE_LOGIN
, CC.MESSAGE_TEXT
, CZ.MESSAGE_STATUS
, CZ.OVERRIDE_FLAG
, CZ.SYSTEM_ID
, CS.NAME SYSTEM_NAME
, CZ.HEADER_ID
, SOH.ORDER_NUMBER
, CZ.LINE_ID
, OE_QUERY.LINE_NUMBER(SOL1.LINE_ID
, SOL1.PARENT_LINE_ID
, SOL1.SHIPMENT_SCHEDULE_LINE_ID
, SOL1.LINE_NUMBER) LINE_NUMBER
, OE_QUERY.SHIPMENT_NUMBER(SOL1.LINE_ID
, SOL1.PARENT_LINE_ID
, SOL1.SHIPMENT_SCHEDULE_LINE_ID
, SOL1.LINE_NUMBER) SHIPMENT_NUMBER
, DECODE(SOL1.PARENT_LINE_ID
, NULL
, NULL
, SOL1.LINE_NUMBER) OPTION_NUMBER
, CZ.ASSIGNMENT_ID
, DECODE(CZ.SYSTEM_ID
, CS.SYSTEM_TYPE_CODE
, MSI.CONCATENATED_SEGMENTS) ENTITY
, DECODE(CZ.SYSTEM_ID
, NULL
, 'I'
, 'S') ENTITY_TYPE
, CZ.REQUEST_ID
, CZ.PROGRAM_APPLICATION_ID
, CZ.PROGRAM_ID
, CZ.PROGRAM_UPDATE_DATE
FROM MTL_SYSTEM_ITEMS_KFV MSI
, SO_LINES_ALL SOL1
, /* THIS LINE */ CZ_CONSTRAINTS_VL CC
, CS_SYSTEMS CS
, SO_HEADERS_ALL SOH
, FND_COMMON_LOOKUPS FND1
, FND_COMMON_LOOKUPS FND2
, CZ_CONSTRAINT_ASSIGNMENTS CA
, CZ_ERRORS CZ
WHERE NVL(CZ.SYSTEM_ID
, -999) = CS.SYSTEM_ID (+)
AND NVL(CZ.HEADER_ID
, -999) = SOH.HEADER_ID (+)
AND NVL(CZ.LINE_ID
, -999) = SOL1.LINE_ID (+)
AND CA.ASSIGNMENT_ID = CZ.ASSIGNMENT_ID
AND CC.CONSTRAINT_ID = CA.CONSTRAINT_ID
AND MSI.INVENTORY_ITEM_ID (+) = SOL1.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = SOL1.WAREHOUSE_ID
AND FND1.LOOKUP_TYPE = 'CZ_CONSTRAINT_TYPES'
AND FND1.LOOKUP_CODE = CC.CONSTRAINT_TYPE
AND FND2.LOOKUP_TYPE = 'CZ_CONSTRAINT_GROUPS'
AND FND2.LOOKUP_CODE = CA.CONSTRAINT_GROUP

Columns