View: MRPBV_PLAN_RESOURCE_LOADS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_PLAN_RESOURCE_LOADS

View Text

SELECT RES.OPERATION_SEQ_NUM
, RES.RESOURCE_SEQ_NUM
, RES.RESOURCE_DATE
, RES.RESOURCE_END_DATE
, RES.RESOURCE_HOURS
, RES.DAILY_RESOURCE_HOURS
, MR.NEW_SCHEDULE_DATE
, MR.LAST_UNIT_COMPLETION_DATE
, MR.NEW_ORDER_QUANTITY
, MR.DAILY_RATE
, RES.LOAD_RATE
, '_LA:RES.REPETITIVE_TYPE:MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING'
, RES.TRANSACTION_ID
, RES.SOURCE_TRANSACTION_ID
, RES.ORGANIZATION_ID
, RES.DESIGNATOR
, RES.DEPARTMENT_ID
, RES.RESOURCE_ID
, TO_NUMBER(NULL)
, RES.ASSEMBLY_ITEM_ID
, RES.SOURCE_ITEM_ID
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
FROM MTL_PARAMETERS MTL
, HR_ALL_ORGANIZATION_UNITS ORG
, BOM_RESOURCES BOM_RES
, BOM_DEPARTMENTS DEPT
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS SYSITEM2
, MRP_RECOMMENDATIONS MR
, CRP_RESOURCE_PLAN RES
WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND DEPT.DEPARTMENT_ID = RES.DEPARTMENT_ID
AND BOM_RES.RESOURCE_ID = RES.RESOURCE_ID
AND SYSITEM2.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND SYSITEM2.INVENTORY_ITEM_ID = NVL(RES.SOURCE_ITEM_ID
, RES.ASSEMBLY_ITEM_ID)
AND SYSITEM.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND SYSITEM.INVENTORY_ITEM_ID = RES.ASSEMBLY_ITEM_ID
AND MR.TRANSACTION_ID = RES.SOURCE_TRANSACTION_ID
AND RES.RESOURCE_ID <> -1
AND '_SEC:RES.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT RES.OPERATION_SEQ_NUM
, RES.RESOURCE_SEQ_NUM
, RES.RESOURCE_DATE
, RES.RESOURCE_END_DATE
, RES.RESOURCE_HOURS
, TO_NUMBER(NULL)
, MR.NEW_SCHEDULE_DATE
, MR.LAST_UNIT_COMPLETION_DATE
, MR.NEW_ORDER_QUANTITY
, RES.DAILY_RESOURCE_HOURS
, RES.LOAD_RATE
, '_LA:RES.REPETITIVE_TYPE:MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING'
, RES.TRANSACTION_ID
, RES.SOURCE_TRANSACTION_ID
, RES.ORGANIZATION_ID
, RES.DESIGNATOR
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, LINE.LINE_ID
, RES.ASSEMBLY_ITEM_ID
, RES.SOURCE_ITEM_ID
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
FROM MTL_PARAMETERS MTL
, HR_ALL_ORGANIZATION_UNITS ORG
, WIP_LINES LINE
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS SYSITEM2
, MRP_RECOMMENDATIONS MR
, CRP_RESOURCE_PLAN RES
WHERE MTL.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND LINE.LINE_ID = RES.DEPARTMENT_ID
AND SYSITEM2.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND SYSITEM2.INVENTORY_ITEM_ID = NVL(RES.SOURCE_ITEM_ID
, RES.ASSEMBLY_ITEM_ID)
AND SYSITEM.ORGANIZATION_ID = RES.ORGANIZATION_ID
AND SYSITEM.INVENTORY_ITEM_ID = RES.ASSEMBLY_ITEM_ID
AND MR.TRANSACTION_ID = RES.SOURCE_TRANSACTION_ID
AND RES.RESOURCE_ID = -1
AND '_SEC:RES.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUGG.FIRST_UNIT_START_DATE
, SUGG.LAST_UNIT_START_DATE
, SUGG.DAILY_RATE
, TO_NUMBER(NULL)
, MR.NEW_SCHEDULE_DATE
, MR.LAST_UNIT_COMPLETION_DATE
, MR.NEW_ORDER_QUANTITY
, MR.DAILY_RATE
, SUGG.LOAD_FACTOR_RATE
, '_LA:DECODE(2
, 2
, 2):MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING'
, -1
, SUGG.TRANSACTION_ID
, SUGG.ORGANIZATION_ID
, SUGG.COMPILE_DESIGNATOR
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, LINE.LINE_ID
, SUGG.INVENTORY_ITEM_ID
, SUGG.SOURCE_ITEM_ID
, SUGG.LAST_UPDATE_DATE
, SUGG.LAST_UPDATED_BY
, SUGG.CREATION_DATE
, SUGG.CREATED_BY
FROM MTL_SYSTEM_ITEMS SYSITEM
, MTL_PARAMETERS MTL
, HR_ALL_ORGANIZATION_UNITS ORG
, WIP_LINES LINE
, MRP_RECOMMENDATIONS MR
, MRP_SUGG_REP_SCHEDULES SUGG
WHERE SYSITEM.INVENTORY_ITEM_ID = SUGG.INVENTORY_ITEM_ID
AND SYSITEM.ORGANIZATION_ID = SUGG.ORGANIZATION_ID
AND MTL.ORGANIZATION_ID = SUGG.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = SUGG.ORGANIZATION_ID
AND LINE.LINE_ID = SUGG.REPETITIVE_LINE
AND MR.TRANSACTION_ID = SUGG.TRANSACTION_ID
AND '_SEC:SUGG.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NVL(MR.NEW_WIP_START_DATE
, MR.NEW_SCHEDULE_DATE)
, NVL(MR.NEW_WIP_START_DATE
, MR.NEW_SCHEDULE_DATE)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MR.NEW_SCHEDULE_DATE
, MR.LAST_UNIT_COMPLETION_DATE
, MR.NEW_ORDER_QUANTITY
, MR.NEW_ORDER_QUANTITY
, MR.NEW_ORDER_QUANTITY
, '_LA:DECODE(1
, 1
, 1):MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING'
, -2
, MR.TRANSACTION_ID
, MR.ORGANIZATION_ID
, MR.COMPILE_DESIGNATOR
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, LINE.LINE_ID
, MR.INVENTORY_ITEM_ID
, MR.SOURCE_ITEM_ID
, MR.LAST_UPDATE_DATE
, MR.LAST_UPDATED_BY
, MR.CREATION_DATE
, MR.CREATED_BY
FROM MTL_SYSTEM_ITEMS SYSITEM
, MTL_PARAMETERS MTL
, HR_ALL_ORGANIZATION_UNITS ORG
, WIP_LINES LINE
, MRP_RECOMMENDATIONS MR
WHERE SYSITEM.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND SYSITEM.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MTL.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MR.LINE_ID IS NOT NULL
AND LINE.LINE_ID = MR.LINE_ID
AND MR.DISPOSITION_STATUS_TYPE <> 2
AND MR.ORDER_TYPE NOT IN (13
, 16
, 4)
AND '_SEC:MR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns