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: ViewMRP.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:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_PLANS
SynonymMRP_PLAN_ORGANIZATIONS
SynonymMRP_SYSTEM_ITEMS
SynonymMTL_ABC_CLASSES
ViewMTL_ITEM_FLEXFIELDS
APPS.MRP_SYSTEM_ITEMS_SC_V is referenced by following:

SchemaAPPS
ViewMRP_WEB_PLAN_ITEMS_V