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_ORG_ITEMS

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

View Text

SELECT PARA1.ORGANIZATION_CODE
, ORG1.NAME
, MRPITEM.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, PARA2.ORGANIZATION_CODE
, ORG2.NAME
, '_KF:INV:MCAT:MTLCAT'
, '_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'
, '_KF:INV:MSTK:BASEITEM'
, MRPITEM.BUYER_NAME
, MTLABC.ABC_CLASS_NAME
, MRPITEM.PLANNER_CODE
, MRPITEM.REVISION
, VENDOR.VENDOR_NAME
, '_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_CATEGORIES MTLCAT
, MTL_ABC_CLASSES MTLABC
, PO_VENDORS VENDOR
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS BASEITEM
, 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 MRPITEM.ORGANIZATION_ID = BASEITEM.ORGANIZATION_ID(+)
AND MRPITEM.BASE_ITEM_ID = BASEITEM.INVENTORY_ITEM_ID(+)
AND MRPITEM.ABC_CLASS = MTLABC.ABC_CLASS_ID(+)
AND MRPITEM.CATEGORY_ID = MTLCAT.CATEGORY_ID(+)
AND MRPITEM.PRIMARY_VENDOR_ID = VENDOR.VENDOR_ID(+)
AND '_SEC:PLAN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ORGANIZATION_CODE
ORGANIZATION_NAME
PLAN_NAME
"_KF:ITEM_NUMBER"
OWNING_ORGANIZATION_NAME
OWNING_ORGANIZATION_CODE
"_KF:CATEGORY_NAME"
"_LA:INVENTORY_TYPE_CODE"
"_LA:MRP_PLANNING_CODE"
ITEM_LOW_LEVEL_CODE
PREPROCESSING_LEAD_TIME
POSTPROCESSING_LEAD_TIME
FULL_LEAD_TIME
CUMULATIVE_TOTAL_LEAD_TIME
CUMULATIVE_MFG_LEAD_TIME
FIXED_LEAD_TIME
VARIABLE_LEAD_TIME
UNIT_OF_MEASURE
"_LA:BUILD_IN_WIP_FLAG"
"_LA:PURCHASING_ENABLED_FLAG"
"_LA:PLANNING_MAKE_BUY_CODE"
"_LA:REPETITIVE_TYPE"
STANDARD_COST
"_LA:LOT_CONTROL"
"_LA:ROUNDING_CONTROL_TYPE"
"_LA:CALCULATE_ATP"
"_LA:END_ASSEMBLY_PEGGING"
NETTABLE_INVENTORY_QUANTITY
NONNETTABLE_INVENTORY_QUANTITY
"_LA:ENGINEERING_ITEM"
"_LA:WIP_SUPPLY_TYPE"
REPETITIVE_OVERRUN_PERCENTAGE
ACCEPTABLE_RATE_INCREASE
ACCEPTABLE_RATE_DECREASE
SAFETY_STOCK_CODE
SAFETY_STOCK_PERCENT_USED
SAFETY_STOCK_BUCKET_DAYS
SAFETY_STOCK_QUANTITY
FIXED_DAYS_SUPPLY
FIXED_ORDER_QUANTITY
FIXED_LOT_MULTIPLIER
MINIMUM_ORDER_QUANTITY
MAXIMUM_ORDER_QUANTITY
PLANNING_TIME_FENCE_DAYS
DEMAND_TIME_FENCE_DAYS
INVENTORY_USE_UP_DATE
ACCEPTABLE_EARLY_DAYS_DELIVERY
PLANNING_EXCEPTION_SET
"_LA:BOM_ITEM_TYPE"
"_LA:FORECAST_CONTROL"
DEMAND_TIME_FENCE_DATE
PEGGING_LEVEL
"_LA:IN_SOURCE_PLAN"
"_KF:BASE_ITEM_NUMBER"
BUYER_NAME
ABC_CLASS_NAME
PLANNER_NAME
REVISION
SUPPLIER_NAME
"_LA:EFFECTIVITY_CONTROL"
ORGANIZATION_ID
INVENTORY_ITEM_ID
OWNING_ORGANIZATION_ID
PRIMARY_SUPPLIER_ID
CATEGORY_ID
BUYER_ID
BASE_ITEM_ID
ABC_CLASS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY