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.

[Home] [Help]

View: MRPFV_PLAN_OPERATION_RESOURCES

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

View Text

SELECT DISTINCT PARA.ORGANIZATION_CODE
, ORG.NAME
, ROUTING.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:ITEM'
, ROUTING.ALTERNATE_ROUTING_DESIGNATOR
, ROUTING.OPERATION_SEQ_NUM
, ROUTING.RESOURCE_SEQ_NUM
, DEPT.DEPARTMENT_CODE
, RES.RESOURCE_CODE
, ROUTING.RESOURCE_OFFSET_PERCENT
, ROUTING.BASIS
, ROUTING.SETBACK_DAYS
, ROUTING.ALTERNATE_ROUTING_DESIGNATOR
, ROUTING.ORGANIZATION_ID
, ROUTING.USING_ASSEMBLY_ITEM_ID
, ROUTING.RESOURCE_ID
, ROUTING.DEPARTMENT_ID
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS ITEM
, MRP_PLANNED_RESOURCE_REQS ROUTING
, BOM_DEPARTMENTS DEPT
, BOM_RESOURCES RES
, MRP_SYSTEM_ITEMS MRPITEM
WHERE DEPT.DEPARTMENT_ID(+) = ROUTING.DEPARTMENT_ID
AND RES.RESOURCE_ID(+) = ROUTING.RESOURCE_ID
AND ROUTING.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND ROUTING.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR
AND ROUTING.USING_ASSEMBLY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = ROUTING.USING_ASSEMBLY_ITEM_ID
AND PARA.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = ROUTING.ORGANIZATION_ID
AND '_SEC:ROUTING.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ORGANIZATION_CODE
ORGANIZATION_NAME
PLAN_NAME
"_KF:ITEM_NUMBER"
ALTERNATE_ROUTING_CODE
OPERATION_SEQUENCE_NUMBER
RESOURCE_SEQUENCE_NUMBER
DEPARTMENT_CODE
RESOURCE_CODE
RESOURCE_OFFSET_PERCENT
OPERATION_BASIS
SETBACK_DAYS
ASSEMBLY_USAGE
ORGANIZATION_ID
USING_ASSEMBLY_ITEM_ID
RESOURCE_ID
DEPARTMENT_ID