VIEW: APPS.MRPFV_PLAN_OPERATION_RESOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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