VIEW: APPS.MRPBV_PLAN_ORG_ITEMS

Source

View Text - Preformatted

SELECT PARA1.ORGANIZATION_CODE , ORG1.NAME , MRPITEM.COMPILE_DESIGNATOR , '_KF:INV:MSTK:SYSITEM' , PARA2.ORGANIZATION_CODE , ORG2.NAME , '_LA:mrpitem.INVENTORY_TYPE:MFG_LOOKUPS:MTL_INVENTORY_TYPES:MEANING' , '_LA:mrpitem.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING' , MRPITEM.LOW_LEVEL_CODE , MRPITEM.PREPROCESSING_LEAD_TIME , MRPITEM.POSTPROCESSING_LEAD_TIME , MRPITEM.FULL_LEAD_TIME , MRPITEM.CUMULATIVE_TOTAL_LEAD_TIME , MRPITEM.CUM_MANUFACTURING_LEAD_TIME , MRPITEM.FIXED_LEAD_TIME , MRPITEM.VARIABLE_LEAD_TIME , MRPITEM.UOM_CODE , '_LA:mrpitem.BUILD_IN_WIP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:mrpitem.PURCHASING_ENABLED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:mrpitem.PLANNING_MAKE_BUY_CODE:MFG_LOOKUPS:MTL_PLANNING_MAKE_BUY:MEANING' , '_LA:mrpitem.REPETITIVE_TYPE:MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING' , MRPITEM.STANDARD_COST , '_LA:mrpitem.LOT_CONTROL_CODE:MFG_LOOKUPS:MTL_LOT_CONTROL:MEANING' , '_LA:mrpitem.ROUNDING_CONTROL_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:mrpitem.CALCULATE_ATP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:mrpitem.END_ASSEMBLY_PEGGING:MFG_LOOKUPS:SYS_YES_NO:MEANING' , MRPITEM.NETTABLE_INVENTORY_QUANTITY , MRPITEM.NONNETTABLE_INVENTORY_QUANTITY , '_LA:mrpitem.ENGINEERING_ITEM_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:mrpitem.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING' , MRPITEM.OVERRUN_PERCENTAGE , MRPITEM.ACCEPTABLE_RATE_INCREASE , MRPITEM.ACCEPTABLE_RATE_DECREASE , MRPITEM.SAFETY_STOCK_CODE , MRPITEM.SAFETY_STOCK_PERCENT , MRPITEM.SAFETY_STOCK_BUCKET_DAYS , MRPITEM.SAFETY_STOCK_QUANTITY , MRPITEM.FIXED_DAYS_SUPPLY , MRPITEM.FIXED_ORDER_QUANTITY , MRPITEM.FIXED_LOT_MULTIPLIER , MRPITEM.MINIMUM_ORDER_QUANTITY , MRPITEM.MAXIMUM_ORDER_QUANTITY , MRPITEM.PLANNING_TIME_FENCE_DAYS , MRPITEM.DEMAND_TIME_FENCE_DAYS , MRPITEM.INVENTORY_USE_UP_DATE , MRPITEM.ACCEPTABLE_EARLY_DELIVERY , MRPITEM.PLANNING_EXCEPTION_SET , '_LA:mrpitem.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING' , '_LA:mrpitem.ATO_FORECAST_CONTROL:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING' , MRPITEM.DEMAND_TIME_FENCE_DATE , MRPITEM.FULL_PEGGING , '_LA:mrpitem.IN_SOURCE_PLAN:MFG_LOOKUPS:SYS_YES_NO:MEANING' , MRPITEM.BUYER_NAME , MRPITEM.PLANNER_CODE , MRPITEM.REVISION , '_LA:mrpitem.EFFECTIVITY_CONTROL:MFG_LOOKUPS:MTL_EFFECTIVITY_CONTROL:MEANING' , NVL(PLANORG.PLANNED_ORGANIZATION,PLAN.ORGANIZATION_ID) , MRPITEM.INVENTORY_ITEM_ID , PLAN.ORGANIZATION_ID , MRPITEM.PRIMARY_VENDOR_ID , MRPITEM.CATEGORY_ID , MRPITEM.BUYER_ID , MRPITEM.BASE_ITEM_ID , MRPITEM.ABC_CLASS , MRPITEM.LAST_UPDATE_DATE , MRPITEM.LAST_UPDATED_BY , MRPITEM.CREATION_DATE , MRPITEM.CREATED_BY FROM MTL_PARAMETERS PARA1 ,MTL_PARAMETERS PARA2 ,HR_ALL_ORGANIZATION_UNITS ORG1 ,HR_ALL_ORGANIZATION_UNITS ORG2 ,MTL_SYSTEM_ITEMS SYSITEM ,MRP_PLANS PLAN ,MRP_PLAN_ORGANIZATIONS PLANORG ,MRP_SYSTEM_ITEMS MRPITEM WHERE MRPITEM.ORGANIZATION_ID = NVL(PLANORG.PLANNED_ORGANIZATION,PLAN.ORGANIZATION_ID) AND MRPITEM.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR AND PLANORG.PLAN_LEVEL(+) = 2 AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID AND MRPITEM.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID AND MRPITEM.INVENTORY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID AND NVL(PLANORG.PLANNED_ORGANIZATION,PLAN.ORGANIZATION_ID) = PARA1.ORGANIZATION_ID AND NVL(PLANORG.PLANNED_ORGANIZATION,PLAN.ORGANIZATION_ID) = ORG1.ORGANIZATION_ID AND PLAN.ORGANIZATION_ID = PARA2.ORGANIZATION_ID AND PLAN.ORGANIZATION_ID = ORG2.ORGANIZATION_ID AND '_SEC:PLAN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PARA1.ORGANIZATION_CODE
, ORG1.NAME
, MRPITEM.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, PARA2.ORGANIZATION_CODE
, ORG2.NAME
, '_LA:MRPITEM.INVENTORY_TYPE:MFG_LOOKUPS:MTL_INVENTORY_TYPES:MEANING'
, '_LA:MRPITEM.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING'
, MRPITEM.LOW_LEVEL_CODE
, MRPITEM.PREPROCESSING_LEAD_TIME
, MRPITEM.POSTPROCESSING_LEAD_TIME
, MRPITEM.FULL_LEAD_TIME
, MRPITEM.CUMULATIVE_TOTAL_LEAD_TIME
, MRPITEM.CUM_MANUFACTURING_LEAD_TIME
, MRPITEM.FIXED_LEAD_TIME
, MRPITEM.VARIABLE_LEAD_TIME
, MRPITEM.UOM_CODE
, '_LA:MRPITEM.BUILD_IN_WIP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MRPITEM.PURCHASING_ENABLED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MRPITEM.PLANNING_MAKE_BUY_CODE:MFG_LOOKUPS:MTL_PLANNING_MAKE_BUY:MEANING'
, '_LA:MRPITEM.REPETITIVE_TYPE:MFG_LOOKUPS:MRP_YES_NO_REVERSED:MEANING'
, MRPITEM.STANDARD_COST
, '_LA:MRPITEM.LOT_CONTROL_CODE:MFG_LOOKUPS:MTL_LOT_CONTROL:MEANING'
, '_LA:MRPITEM.ROUNDING_CONTROL_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MRPITEM.CALCULATE_ATP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MRPITEM.END_ASSEMBLY_PEGGING:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MRPITEM.NETTABLE_INVENTORY_QUANTITY
, MRPITEM.NONNETTABLE_INVENTORY_QUANTITY
, '_LA:MRPITEM.ENGINEERING_ITEM_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MRPITEM.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, MRPITEM.OVERRUN_PERCENTAGE
, MRPITEM.ACCEPTABLE_RATE_INCREASE
, MRPITEM.ACCEPTABLE_RATE_DECREASE
, MRPITEM.SAFETY_STOCK_CODE
, MRPITEM.SAFETY_STOCK_PERCENT
, MRPITEM.SAFETY_STOCK_BUCKET_DAYS
, MRPITEM.SAFETY_STOCK_QUANTITY
, MRPITEM.FIXED_DAYS_SUPPLY
, MRPITEM.FIXED_ORDER_QUANTITY
, MRPITEM.FIXED_LOT_MULTIPLIER
, MRPITEM.MINIMUM_ORDER_QUANTITY
, MRPITEM.MAXIMUM_ORDER_QUANTITY
, MRPITEM.PLANNING_TIME_FENCE_DAYS
, MRPITEM.DEMAND_TIME_FENCE_DAYS
, MRPITEM.INVENTORY_USE_UP_DATE
, MRPITEM.ACCEPTABLE_EARLY_DELIVERY
, MRPITEM.PLANNING_EXCEPTION_SET
, '_LA:MRPITEM.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:MRPITEM.ATO_FORECAST_CONTROL:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING'
, MRPITEM.DEMAND_TIME_FENCE_DATE
, MRPITEM.FULL_PEGGING
, '_LA:MRPITEM.IN_SOURCE_PLAN:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MRPITEM.BUYER_NAME
, MRPITEM.PLANNER_CODE
, MRPITEM.REVISION
, '_LA:MRPITEM.EFFECTIVITY_CONTROL:MFG_LOOKUPS:MTL_EFFECTIVITY_CONTROL:MEANING'
, NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID)
, MRPITEM.INVENTORY_ITEM_ID
, PLAN.ORGANIZATION_ID
, MRPITEM.PRIMARY_VENDOR_ID
, MRPITEM.CATEGORY_ID
, MRPITEM.BUYER_ID
, MRPITEM.BASE_ITEM_ID
, MRPITEM.ABC_CLASS
, MRPITEM.LAST_UPDATE_DATE
, MRPITEM.LAST_UPDATED_BY
, MRPITEM.CREATION_DATE
, MRPITEM.CREATED_BY
FROM MTL_PARAMETERS PARA1
, MTL_PARAMETERS PARA2
, HR_ALL_ORGANIZATION_UNITS ORG1
, HR_ALL_ORGANIZATION_UNITS ORG2
, MTL_SYSTEM_ITEMS SYSITEM
, MRP_PLANS PLAN
, MRP_PLAN_ORGANIZATIONS PLANORG
, MRP_SYSTEM_ITEMS MRPITEM
WHERE MRPITEM.ORGANIZATION_ID = NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID)
AND MRPITEM.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR
AND PLANORG.PLAN_LEVEL(+) = 2
AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR
AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID
AND MRPITEM.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID
AND MRPITEM.INVENTORY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID
AND NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID) = PARA1.ORGANIZATION_ID
AND NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID) = ORG1.ORGANIZATION_ID
AND PLAN.ORGANIZATION_ID = PARA2.ORGANIZATION_ID
AND PLAN.ORGANIZATION_ID = ORG2.ORGANIZATION_ID
AND '_SEC:PLAN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY