[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | An Integration Toolkit view supporting information regarding material requirement for open discrete job |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_NUMBER
, ITEMS.ORGANIZATION_ID
, ENT.WIP_ENTITY_ID
, ENT.WIP_ENTITY_NAME
, WRO.OPERATION_SEQ_NUM
, WRO.REQUIRED_QUANTITY
, WRO.QUANTITY_ISSUED
, WRO.DATE_REQUIRED
, WRO.QUANTITY_PER_ASSEMBLY
, JOBS.PRIMARY_ITEM_ID
, JOBS.JOB_TYPE
, JOBS.ALTERNATE_BOM_DESIGNATOR
, JOBS.ALTERNATE_ROUTING_DESIGNATOR
, JOBS.ATTRIBUTE_CATEGORY
, JOBS.ATTRIBUTE1
, JOBS.ATTRIBUTE2
, JOBS.ATTRIBUTE3
, JOBS.ATTRIBUTE4
, JOBS.ATTRIBUTE5
, JOBS.ATTRIBUTE6
, JOBS.ATTRIBUTE7
, JOBS.ATTRIBUTE8
, JOBS.ATTRIBUTE9
, JOBS.ATTRIBUTE10
, JOBS.ATTRIBUTE11
, JOBS.ATTRIBUTE12
, JOBS.ATTRIBUTE13
, JOBS.ATTRIBUTE14
, JOBS.ATTRIBUTE15
, WRO.ATTRIBUTE_CATEGORY
, WRO.ATTRIBUTE1
, WRO.ATTRIBUTE2
, WRO.ATTRIBUTE3
, WRO.ATTRIBUTE4
, WRO.ATTRIBUTE5
, WRO.ATTRIBUTE6
, WRO.ATTRIBUTE7
, WRO.ATTRIBUTE8
, WRO.ATTRIBUTE9
, WRO.ATTRIBUTE10
, WRO.ATTRIBUTE11
, WRO.ATTRIBUTE12
, WRO.ATTRIBUTE13
, WRO.ATTRIBUTE14
, WRO.ATTRIBUTE15
FROM MRP_RHX_PLANNED_ITEMS_V ITEMS
, WIP_REQUIREMENT_OPERATIONS WRO
, WIP_DISCRETE_JOBS JOBS
, WIP_ENTITIES ENT
WHERE ITEMS.ORGANIZATION_ID = WRO.ORGANIZATION_ID
AND ITEMS.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
AND WRO.QUANTITY_ISSUED <= WRO.REQUIRED_QUANTITY
AND WRO.REQUIRED_QUANTITY > 0
AND WRO.WIP_SUPPLY_TYPE NOT IN (5
, 6)
AND WRO.MRP_NET_FLAG = 1
AND WRO.ORGANIZATION_ID = JOBS.ORGANIZATION_ID
AND WRO.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID
AND JOBS.STATUS_TYPE IN (1
, 3
, 4
, 6)
AND JOBS.WIP_ENTITY_ID = ENT.WIP_ENTITY_ID
AND JOBS.ORGANIZATION_ID = ENT.ORGANIZATION_ID