Product: | WIP - Work in Process |
---|---|
Description: | Errors encountered while processing Open Scheduling Interface requests |
Implementation/DBA Data: | APPS.WIP_SCHEDULING_ERRORS_V |
SELECT WSI.GROUP_ID
, ML2.MEANING
, ML3.MEANING
, WE.WIP_ENTITY_NAME
, WIE.ERROR
, ML1.MEANING
, WSI.OPERATION_SEQ_NUM
, WSI.OPERATION_START_DATE
, WSI.OPERATION_COMPLETION_DATE
, WSI.RESOURCE_SEQ_NUM
, WSI.RESOURCE_START_DATE
, WSI.RESOURCE_COMPLETION_DATE
, WSI.USAGE_RATE_OR_AMOUNT
, WSI.SCHEDULING_LEVEL
, WSI.WIP_ENTITY_ID
, WSI.ORGANIZATION_ID
, WSI.PROCESS_PHASE
, WSI.PROCESS_STATUS
, WIE.INTERFACE_ID
FROM WIP_INTERFACE_ERRORS WIE
, WIP_ENTITIES WE
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, WIP_SCHEDULING_INTERFACE WSI
WHERE WIE.INTERFACE_ID = WSI.INTERFACE_ID
AND ML1.LOOKUP_TYPE(+) = 'WIP_SCHEDULING_LEVEL'
AND ML1.LOOKUP_CODE(+) = WSI.SCHEDULING_LEVEL
AND ML2.LOOKUP_TYPE(+) = 'WIP_ML_PROCESS_PHASE'
AND ML2.LOOKUP_CODE(+) = WSI.PROCESS_PHASE
AND ML3.LOOKUP_TYPE(+) = 'WIP_PROCESS_STATUS'
AND ML3.LOOKUP_CODE(+) = WSI.PROCESS_STATUS
AND WE.WIP_ENTITY_ID(+) = WSI.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID(+) = WSI.ORGANIZATION_ID