View: WIP_JOB_ASSY_LINE_V

Product:	WIP - Work in Process
Description:	Jobs, Repetitive Schedules, Flow Schedules and their assemblies and lines
Implementation/DBA Data:	APPS.WIP_JOB_ASSY_LINE_V

View Text

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)

Columns