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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MRP_SYSTEM_ITEMS_SC_V

Object Details

Object Name:	MRP_SYSTEM_ITEMS_SC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_SYSTEM_ITEMS_SC_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM_SEGMENTS	VARCHAR2	(40)		Item segments
ORGANIZATION_ID	NUMBER			Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
PLAN_ORGANIZATION_ID	NUMBER		Yes	Planned organization Identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
MRP_PLANNING_CODE_TEXT	VARCHAR2	(80)	Yes	Planning code meaning
PREPROCESSING_LEAD_TIME	NUMBER			Pre processing lead time
POSTPROCESSING_LEAD_TIME	NUMBER			Post processing lead time
FULL_LEAD_TIME	NUMBER		Yes	Full lead time
FIXED_LEAD_TIME	NUMBER			Fixed lead time
VARIABLE_LEAD_TIME	NUMBER			Variable lead time
PLANNING_MAKE_BUY_CODE_TEXT	VARCHAR2	(80)	Yes	Make or buy meaning
REPETITIVE_TYPE	NUMBER		Yes	Is this item built repetitively?
STANDARD_COST	NUMBER			Standard costs
ROUNDING_CONTROL_TYPE	NUMBER		Yes	Order rounding control type code
NETTABLE_INVENTORY_QUANTITY	NUMBER			Nettable inventory quantity on hand
NONNETTABLE_INVENTORY_QUANTITY	NUMBER			Non nettable inventory quantity on hand
WIP_SUPPLY_TYPE_TEXT	VARCHAR2	(80)		WIP supply type meaning
DESCRIPTION	VARCHAR2	(240)		Inventory item description
CATEGORY_ID	NUMBER			Category identifier for the planning category set
BUYER_NAME	VARCHAR2	(240)		Buyer name
PLANNER_CODE	VARCHAR2	(10)		Planner code
ABC_CLASS_NAME	VARCHAR2	(40)		Class name
FIXED_DAYS_SUPPLY	NUMBER			Fixed days supply
FIXED_ORDER_QUANTITY	NUMBER			Fixed order quantity
FIXED_LOT_MULTIPLIER	NUMBER			Fixed lot multiplier
MINIMUM_ORDER_QUANTITY	NUMBER			Minimum order quantity
MAXIMUM_ORDER_QUANTITY	NUMBER			Maximum order quantity
SHRINKAGE_RATE	NUMBER			Expected loss due to scrap
PLANNING_EXCEPTION_SET	VARCHAR2	(10)		Planning exception set to use to generate exception messages
BASE_ITEM_ID	NUMBER			Base model for this configuration
BOM_ITEM_TYPE_TEXT	VARCHAR2	(80)		BOM item type meaning
ATO_FORECAST_CONTROL_TEXT	VARCHAR2	(80)		Forecast control meaning
PRIMARY_VENDOR_ID	NUMBER			Supplier identifier
IN_SOURCE_PLAN	NUMBER			Whether the item is planned in the source plan or not
PLANNING_MAKE_BUY_CODE	NUMBER			Plan this item as either a make item or buy item
EFFECTIVITY_CONTROL	NUMBER			effectivity control
EFFECTIVITY_CONTROL_TYPE	VARCHAR2	(80)		effectivity control type: could be by date or unit number
PLANNING_TIME_FENCE_DATE	DATE			planning time fence date
UOM_CODE	VARCHAR2	(3)	Yes	Unit of measurement

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      MRP_PLANNING_CODE_TEXT
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      PLANNING_MAKE_BUY_CODE_TEXT
,      REPETITIVE_TYPE
,      STANDARD_COST
,      ROUNDING_CONTROL_TYPE
,      NETTABLE_INVENTORY_QUANTITY
,      NONNETTABLE_INVENTORY_QUANTITY
,      WIP_SUPPLY_TYPE_TEXT
,      DESCRIPTION
,      CATEGORY_ID
,      BUYER_NAME
,      PLANNER_CODE
,      ABC_CLASS_NAME
,      FIXED_DAYS_SUPPLY
,      FIXED_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      SHRINKAGE_RATE
,      PLANNING_EXCEPTION_SET
,      BASE_ITEM_ID
,      BOM_ITEM_TYPE_TEXT
,      ATO_FORECAST_CONTROL_TEXT
,      PRIMARY_VENDOR_ID
,      IN_SOURCE_PLAN
,      PLANNING_MAKE_BUY_CODE
,      EFFECTIVITY_CONTROL
,      EFFECTIVITY_CONTROL_TYPE
,      PLANNING_TIME_FENCE_DATE
,      UOM_CODE
FROM APPS.MRP_SYSTEM_ITEMS_SC_V;

Dependencies

[top of page]

APPS.MRP_SYSTEM_ITEMS_SC_V references the following:

APPS: MFG_LOOKUPS; MRP_PLANS; MRP_PLAN_ORGANIZATIONS; MRP_SYSTEM_ITEMS; MTL_ABC_CLASSES; MTL_ITEM_FLEXFIELDS

APPS.MRP_SYSTEM_ITEMS_SC_V is referenced by following:

APPS: MRP_WEB_PLAN_ITEMS_V