View: WIP_MATERIAL_SHORTAGES_V

Product:	WIP - Work in Process
Description:	Material shortage data
Implementation/DBA Data:	APPS.WIP_MATERIAL_SHORTAGES_V

View Text

SELECT WE.WIP_ENTITY_NAME
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WE.ENTITY_TYPE WIP_ENTITY_TYPE
, WRO.REPETITIVE_SCHEDULE_ID
, WRS.LINE_ID REPETITIVE_LINE_ID
, WRO.OPERATION_SEQ_NUM
, WRO.DEPARTMENT_ID
, WRO.INVENTORY_ITEM_ID
, WRO.QUANTITY_BACKORDERED
, MSI.PRIMARY_UOM_CODE UOM_CODE
, DECODE(WRO.WIP_SUPPLY_TYPE
, 1
, WRO.SUPPLY_SUBINVENTORY
, NVL(WRO.SUPPLY_SUBINVENTORY
, WP.DEFAULT_PULL_SUPPLY_SUBINV)) SUBINVENTORY_CODE
, DECODE(WRO.WIP_SUPPLY_TYPE
, 1
, WRO.SUPPLY_LOCATOR_ID
, DECODE(WRO.SUPPLY_SUBINVENTORY
, NULL
, WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID
, WRO.SUPPLY_LOCATOR_ID)) LOCATOR_ID
, DECODE(WRO.WIP_SUPPLY_TYPE
, 1
, DECODE(WRO.SUPPLY_SUBINVENTORY
, NULL
, 'Y'
, 'N')
, 'N') WIP_ISSUE_FLAG
, WDJ2.PROJECT_ID
, WDJ2.TASK_ID
, WRO.DATE_REQUIRED
, WRO.WIP_SUPPLY_TYPE
FROM WIP_REQUIREMENT_OPERATIONS WRO
, WIP_ENTITIES WE
, MTL_SYSTEM_ITEMS MSI
, WIP_DISCRETE_JOBS WDJ2
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_PARAMETERS WP
WHERE WE.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WE.WIP_ENTITY_ID = WDJ2.WIP_ENTITY_ID(+)
AND WRO.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID (+)
AND WRO.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND WRO.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID = WP.ORGANIZATION_ID
AND WRO.QUANTITY_BACKORDERED > 0
AND ( ( WE.ENTITY_TYPE IN (1
, 5
, 6)
AND EXISTS(SELECT 'TRANSACTABLE JOB'
FROM WIP_DISCRETE_JOBS WDJ
WHERE WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE IN (3
, 4) ) ) OR ( WE.ENTITY_TYPE = 2
AND EXISTS(SELECT 'TRANSACTABLE SCHEDULE'
FROM WIP_REPETITIVE_SCHEDULES WRS2
WHERE WRO.REPETITIVE_SCHEDULE_ID = WRS2.REPETITIVE_SCHEDULE_ID
AND WRS2.STATUS_TYPE IN (3
, 4) ) ) )

Columns