VIEW: APPS.WIP_SCHEDULING_ERRORS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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