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