VIEW: APPS.WIP_JOB_ASSY_LINE_V

Source

View Text - Preformatted

SELECT WE.ORGANIZATION_ID , WE.WIP_ENTITY_ID , WE.PRIMARY_ITEM_ID , WE.WIP_ENTITY_NAME , to_number(NULL) LINE_ID, to_char(NULL) LINE_CODE FROM WIP_ENTITIES WE WHERE WE.ENTITY_TYPE in (1,3,5,6,7,8) union (select WE.ORGANIZATION_ID, WE.WIP_ENTITY_ID, WE.PRIMARY_ITEM_ID, NULL WIP_ENTITY_NAME, WRI.LINE_ID, WL.LINE_CODE FROM WIP_LINES WL , WIP_REPETITIVE_ITEMS WRI, WIP_ENTITIES WE WHERE WE.ENTITY_TYPE = 2 AND WRI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND WRI.ORGANIZATION_ID = WE.ORGANIZATION_ID AND WL.LINE_ID = WRI.LINE_ID AND WL.ORGANIZATION_ID = WRI.ORGANIZATION_ID ) union (select WE.ORGANIZATION_ID, WE.WIP_ENTITY_ID, WE.PRIMARY_ITEM_ID, WE.WIP_ENTITY_NAME, WFL.LINE_ID, WL.LINE_CODE FROM WIP_LINES WL , WIP_FLOW_SCHEDULES WFL, WIP_ENTITIES WE WHERE WE.ENTITY_TYPE = 4 AND WFL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND WFL.ORGANIZATION_ID = WE.ORGANIZATION_ID AND WL.LINE_ID (+) = WFL.LINE_ID AND WL.ORGANIZATION_ID (+) = WFL.ORGANIZATION_ID)

View Text - HTML Formatted

SELECT WE.ORGANIZATION_ID
, WE.WIP_ENTITY_ID
, WE.PRIMARY_ITEM_ID
, WE.WIP_ENTITY_NAME
, TO_NUMBER(NULL) LINE_ID
, TO_CHAR(NULL) LINE_CODE
FROM WIP_ENTITIES WE
WHERE WE.ENTITY_TYPE IN (1
, 3
, 5
, 6
, 7
, 8) UNION (SELECT WE.ORGANIZATION_ID
, WE.WIP_ENTITY_ID
, WE.PRIMARY_ITEM_ID
, NULL WIP_ENTITY_NAME
, WRI.LINE_ID
, WL.LINE_CODE
FROM WIP_LINES WL
, WIP_REPETITIVE_ITEMS WRI
, WIP_ENTITIES WE
WHERE WE.ENTITY_TYPE = 2
AND WRI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WRI.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WL.LINE_ID = WRI.LINE_ID
AND WL.ORGANIZATION_ID = WRI.ORGANIZATION_ID ) UNION (SELECT WE.ORGANIZATION_ID
, WE.WIP_ENTITY_ID
, WE.PRIMARY_ITEM_ID
, WE.WIP_ENTITY_NAME
, WFL.LINE_ID
, WL.LINE_CODE
FROM WIP_LINES WL
, WIP_FLOW_SCHEDULES WFL
, WIP_ENTITIES WE
WHERE WE.ENTITY_TYPE = 4
AND WFL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WFL.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WL.LINE_ID (+) = WFL.LINE_ID
AND WL.ORGANIZATION_ID (+) = WFL.ORGANIZATION_ID)