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: MRP_I2_DUMMY_PART_MASTER_V

Product:	MRP - Master Scheduling/MRP
Description:	A Rhythm view supporting information regarding parts planned in Rhythm
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT I.ITEM_NUMBER
, I.INVENTORY_ITEM_ID
, I.DESCRIPTION
, I.ORGANIZATION_ID
, I.PLANNING_MAKE_BUY_CODE
, DECODE(I.PLANNING_TIME_FENCE_DAYS
, 0
, MRP_I2_ERP.GET_PARAMETER( 'DEFAULT_PLANNING_TF_OFFSET'
, I.ORGANIZATION_ID) + NVL(I.POSTPROCESSING_LEAD_TIME
, 0) + NVL(I.FULL_LEAD_TIME
, 0)
, I.PLANNING_TIME_FENCE_DAYS)
, DECODE(MRP_I2_ERP.GET_PARAMETER('CONSIDER_DEMAND_TF'
, I.ORGANIZATION_ID)
, 'Y'
, I.DEMAND_TIME_FENCE_DAYS
, 0)
, NVL(I.PREPROCESSING_LEAD_TIME
, 0) + NVL(I.FULL_LEAD_TIME
, 0)
, NVL(I.POSTPROCESSING_LEAD_TIME
, 0)
, NVL(I.MINIMUM_ORDER_QUANTITY
, NVL(I.FIXED_LOT_MULTIPLIER
, 0))
, NVL(I.MAXIMUM_ORDER_QUANTITY
, 999999999)
, DECODE(I.ROUNDING_CONTROL_TYPE
, 1
, CEIL(NVL(I.FIXED_LOT_MULTIPLIER
, 1))
, NVL(I.FIXED_LOT_MULTIPLIER
, 0.00001))
, NVL(I.FIXED_DAYS_SUPPLY
, 1)
, I.PLANNER_CODE
, I.PRIMARY_UOM_CODE
, I.CUSTOMER_ORDER_FLAG
, SUBSTR( I.CATEGORY_NAME
, 1
, 240)
, I.BUYER_ID
, NVL(I.REPLENISH_TO_ORDER_FLAG
, 'N')
, DECODE(I.WIP_SUPPLY_TYPE
, 6
, 'Y'
, 'N')
FROM MRP_RHX_PLANNED_ITEMS_V I
WHERE I.MRP_PLANNING_CODE IN (3
, 4
, 7
, 8)

Columns

Name
PART_NUMBER
INVENTORY_ITEM_ID
DESCRIPTION
ORGANIZATION_ID
MAKE_OR_BUY_CODE
PLANNING_TIME_FENCE
DEMAND_TIME_FENCE
LEADTIME
POSTPROCESSING_LEADTIME
MINIMUM_ORDER_QUANTITY
MAXIMUM_ORDER_QUANTITY
INCREMENTAL_LOT_SIZE
FIXED_DAYS_SUPPLY
PLANNER_CODE
UOM
SELLABLE
CATEGORY
BUYER_ID
ASSEMBLE_TO_ORDER
PHANTOM_FLAG