[Home] [Help]
View: MRPBV_PLAN_OPERATIONS
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.EFFECTIVITY_DATE
, ROUTING.DISABLE_DATE
, ROUTING.ORGANIZATION_ID
, ROUTING.USING_ASSEMBLY_ITEM_ID
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS ITEM
, MRP_PLANNED_RESOURCE_REQS ROUTING
, MRP_SYSTEM_ITEMS MRPITEM
WHERE 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 |
EFFECTIVITY_DATE |
DISABLE_DATE |
ORGANIZATION_ID |
USING_ASSEMBLY_ITEM_ID |