[Home] [Help]
View: WIP_BIS_LATE_PROD_COMP_V
Product: | WIP - Work in Process |
Description: | Discrete jobs or repetitive schedules that completed late |
Implementation/DBA Data: |
APPS.WIP_BIS_LATE_PROD_COMP_V
|
View Text
SELECT MIF.ORGANIZATION_ID
, MIF.ITEM_NUMBER
, MIF.PRIMARY_UOM_CODE
, MIF.DESCRIPTION
, WL.LINE_CODE
, WE.WIP_ENTITY_NAME
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.DATE_COMPLETED
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_LINES WL
, MTL_ITEM_FLEXFIELDS MIF
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WDJ.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND WDJ.PRIMARY_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND NVL(WDJ.DATE_COMPLETED
, SYSDATE) > WDJ.SCHEDULED_COMPLETION_DATE
AND WDJ.STATUS_TYPE IN (3
, 4
, 5
, 12)
AND WL.LINE_ID (+) = WDJ.LINE_ID UNION SELECT MIF.ORGANIZATION_ID
, MIF.ITEM_NUMBER
, MIF.PRIMARY_UOM_CODE
, MIF.DESCRIPTION
, WL.LINE_CODE
, WE.WIP_ENTITY_NAME
, WRS.LAST_UNIT_COMPLETION_DATE
, WRS.DATE_CLOSED
FROM WIP_ENTITIES WE
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_REPETITIVE_ITEMS WRI
, WIP_LINES WL
, MTL_ITEM_FLEXFIELDS MIF
WHERE WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WRS.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND NVL(WRS.DATE_CLOSED
, SYSDATE) > WRS.LAST_UNIT_COMPLETION_DATE
AND WRS.STATUS_TYPE IN (3
, 4
, 5
, 12)
AND WRI.LINE_ID = WRS.LINE_ID
AND MIF.INVENTORY_ITEM_ID = WRI.PRIMARY_ITEM_ID
AND WL.LINE_ID = WRS.LINE_ID
Columns
Name |
ORGANIZATION_ID |
ITEM_NUMBER |
ITEM_UOM |
ITEM_DESCRIPTION |
LINE |
WIP_ENTITY_NAME |
SCHED_COMP_DATE |
ACTUAL_COMP_DATE |