[Home] [Help]
View: MRP_RHX_JOBS_RESOURCES_REQ_V
| Product: | MRP - Master Scheduling/MRP |
|---|
| Description: | An Integration Toolkit view supporting info regarding resource requirements for open discrete jobs |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| INVENTORY_ITEM_ID |
| PART_NUMBER |
| OPERATION_SEQ_NUM |
| OPERATION_SEQUENCE_ID |
| DESCRIPTION |
| USAGE_RATE |
| DEPARTMENT_ID |
| RESOURCE_SEQ_NUM |
| RESOURCE_ID |
| ORGANIZATION_ID |
| COMMON_BILL_SEQUENCE_ID |
| COMMON_ROUTING_SEQUENCE_ID |
| ALT_BOM_DESIGNATOR |
| ALT_ROUTING_DESIGNATOR |
| START_DATE |
| COMPLETION_DATE |
| ASSIGNED_UNITS |
| APPLIED_RESOURCE_UNITS |
| BASIS_TYPE |
| WIP_ENTITY_ID |
| WDJ_ATTRIBUTE_CATEGORY |
| WDJ_ATTRIBUTE1 |
| WDJ_ATTRIBUTE2 |
| WDJ_ATTRIBUTE3 |
| WDJ_ATTRIBUTE4 |
| WDJ_ATTRIBUTE5 |
| WDJ_ATTRIBUTE6 |
| WDJ_ATTRIBUTE7 |
| WDJ_ATTRIBUTE8 |
| WDJ_ATTRIBUTE9 |
| WDJ_ATTRIBUTE10 |
| WDJ_ATTRIBUTE11 |
| WDJ_ATTRIBUTE12 |
| WDJ_ATTRIBUTE13 |
| WDJ_ATTRIBUTE14 |
| WDJ_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 |
| RESOURCE_SETUP |
| Name |