[Home] [Help]
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
Name |
ORGANIZATION_ID |
WIP_ENTITY_ID |
PRIMARY_ITEM_ID |
WIP_ENTITY_NAME |
LINE_ID |
LINE_CODE |