View: MRP_RHX_JOBS_RESOURCES_REQ_V

View Text

SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_NUMBER
, WO.OPERATION_SEQ_NUM
, WO.OPERATION_SEQUENCE_ID
, WO.DESCRIPTION
, WOR.USAGE_RATE_OR_AMOUNT
, WO.DEPARTMENT_ID
, WOR.RESOURCE_SEQ_NUM
, WOR.RESOURCE_ID
, WOR.ORGANIZATION_ID
, JOBS.COMMON_BOM_SEQUENCE_ID
, JOBS.COMMON_ROUTING_SEQUENCE_ID
, JOBS.ALTERNATE_BOM_DESIGNATOR
, JOBS.ALTERNATE_ROUTING_DESIGNATOR
, WOR.START_DATE
, WOR.COMPLETION_DATE
, WOR.ASSIGNED_UNITS
, WOR.APPLIED_RESOURCE_UNITS
, WOR.BASIS_TYPE
, JOBS.WIP_ENTITY_ID
, 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
, WO.ATTRIBUTE_CATEGORY
, WO.ATTRIBUTE1
, WO.ATTRIBUTE2
, WO.ATTRIBUTE3
, WO.ATTRIBUTE4
, WO.ATTRIBUTE5
, WO.ATTRIBUTE6
, WO.ATTRIBUTE7
, WO.ATTRIBUTE8
, WO.ATTRIBUTE9
, WO.ATTRIBUTE10
, WO.ATTRIBUTE11
, WO.ATTRIBUTE12
, WO.ATTRIBUTE13
, WO.ATTRIBUTE14
, WO.ATTRIBUTE15
, WOR.ATTRIBUTE_CATEGORY
, WOR.ATTRIBUTE1
, WOR.ATTRIBUTE2
, WOR.ATTRIBUTE3
, WOR.ATTRIBUTE4
, WOR.ATTRIBUTE5
, WOR.ATTRIBUTE6
, WOR.ATTRIBUTE7
, WOR.ATTRIBUTE8
, WOR.ATTRIBUTE9
, WOR.ATTRIBUTE10
, WOR.ATTRIBUTE11
, WOR.ATTRIBUTE12
, WOR.ATTRIBUTE13
, WOR.ATTRIBUTE14
, WOR.ATTRIBUTE15
, DECODE(WOR.BASIS_TYPE
, 2
, WOR.USAGE_RATE_OR_AMOUNT
, 0)
FROM WIP_OPERATION_RESOURCES WOR
, WIP_OPERATIONS WO
, WIP_DISCRETE_JOBS JOBS
, MRP_RHX_PLANNED_ITEMS_V ITEMS
WHERE JOBS.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND JOBS.PRIMARY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND JOBS.STATUS_TYPE IN (1
, 3
, 4
, 6)
AND WO.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = JOBS.ORGANIZATION_ID
AND JOBS.START_QUANTITY - NVL(JOBS.QUANTITY_COMPLETED
, 0) > 0
AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND WOR.SCHEDULED_FLAG IN (1
, 3
, 4)

Columns