eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRPBV_PLAN_RESOURCE_LOADS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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