Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT ER.ERROR_ID
, SY.NAME
, HE.ORDER_NUMBER
, LI.LINE_NUMBER
, CO.NAME
, '_KF:INV:MSTK:SYIT'
, PA.ORGANIZATION_CODE
, AL.NAME
, COLO.MEANING
, '_LA:ER.OVERRIDE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, ER.SYSTEM_ID
, ER.HEADER_ID
, ER.LINE_ID
, ER.ASSIGNMENT_ID
, ER.GROUP_ID
, ER.CREATION_DATE
, ER.CREATED_BY
, ER.LAST_UPDATE_DATE
, ER.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUPS COLO
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SYIT
, CZ_CONSTRAINTS_VL CO
, CZ_CONSTRAINT_ASSIGNMENTS COAS
, SO_LINES_ALL LI
, SO_HEADERS_ALL HE
, CS_SYSTEMS SY
, CZ_ERRORS ER
WHERE ER.SYSTEM_ID = SY.SYSTEM_ID(+)
AND ER.HEADER_ID = HE.HEADER_ID(+)
AND ER.LINE_ID = LI.LINE_ID(+)
AND ER.ASSIGNMENT_ID = COAS.ASSIGNMENT_ID
AND COAS.CONSTRAINT_ID = CO.CONSTRAINT_ID
AND COAS.INVENTORY_ITEM_ID = SYIT.INVENTORY_ITEM_ID(+)
AND COAS.ORGANIZATION_ID = SYIT.ORGANIZATION_ID(+)
AND COAS.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND COAS.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND COAS.SYSTEM_TYPE_CODE = COLO.LOOKUP_CODE(+)
AND COLO.APPLICATION_ID(+) = 702
AND COLO.LOOKUP_TYPE(+) = 'CZ_SYSTEM_TYPES' WITH READ ONLY