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

TABLE: MSC.MSC_ITEM_FCST_SR_LEVELS

Object Details
Object Name: MSC_ITEM_FCST_SR_LEVELS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This table stores hierarchy of sourcing for items that are part of Global Forecast.
This information is used internally to derive items to be included in plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ITEM_FCST_SR_LEVELS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INVENTORY_ITEM_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
SR_INVENTORY_ITEM_ID NUMBER

Source Inventory Item Id
ORGANIZATION_ID NUMBER

Organization Id
SR_INSTANCE_ID NUMBER

Source instance id
PLAN_ID NUMBER

Plan id
ASSIGNMENT_TYPE NUMBER

Assignment type
ASSIGNMENT_SET_ID NUMBER

Assignment set id
SOURCING_RULE_TYPE NUMBER

Sourcing rule type
SOURCE_ORGANIZATION_ID NUMBER

Source organization id
SOURCE_ORG_INSTANCE_ID NUMBER

Source organization instance id
VENDOR_ID NUMBER

Vendor id
VENDOR_SITE_ID NUMBER

Vendor site id
ALLOCATION_PERCENT NUMBER

Allocation percent
RANK NUMBER

Rank
EFFECTIVE_DATE DATE

Effective date
DISABLE_DATE DATE

Disable date
CATEGORY_ID NUMBER

Category id
SOURCING_LEVEL NUMBER

Internal number representing hierarchy of sourcing.
ASSIGNMENT_ID NUMBER

Assignment Id
SOURCING_RULE_ID NUMBER

Sourcing rule id
SOURCING_RULE_NAME VARCHAR2 (80)
Sourcing rule name
SOURCE_TYPE NUMBER

Source type
SOURCE_ORG_CODE VARCHAR2 (6)
Source organization code
SR_DESCRIPTION VARCHAR2 (80)
Sourcing rule description
COMPILE_DESIGNATOR VARCHAR2 (10)
Plan name
OWNING_ORG_ID NUMBER

Owning Organization id
MRP_PLANNING_CODE NUMBER

MRP planning code
BOM_ITEM_TYPE NUMBER

BOM Item type
PLANNING_MAKE_BUY_CODE NUMBER

Planning make/buy code
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary UOM code
COMP_MRP_PLANNING_CODE NUMBER

Component MRP planning code
CUSTOMER_ID NUMBER

Customer id
CUSTOMER_SITE_ID NUMBER

Customer site id
ZONE_ID NUMBER

Zone id
ASSY_DRP_PLANNED NUMBER

Assembly item drp planned flag
COMP_DRP_PLANNED NUMBER

Component item drp planned flag
Query Text

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


SELECT INVENTORY_ITEM_ID
,      SR_INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      PLAN_ID
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_SET_ID
,      SOURCING_RULE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ALLOCATION_PERCENT
,      RANK
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      CATEGORY_ID
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SOURCE_ORG_CODE
,      SR_DESCRIPTION
,      COMPILE_DESIGNATOR
,      OWNING_ORG_ID
,      MRP_PLANNING_CODE
,      BOM_ITEM_TYPE
,      PLANNING_MAKE_BUY_CODE
,      PRIMARY_UOM_CODE
,      COMP_MRP_PLANNING_CODE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ZONE_ID
,      ASSY_DRP_PLANNED
,      COMP_DRP_PLANNED
FROM MSC.MSC_ITEM_FCST_SR_LEVELS;

Dependencies

[top of page]

MSC.MSC_ITEM_FCST_SR_LEVELS does not reference any database object

MSC.MSC_ITEM_FCST_SR_LEVELS is referenced by following:

SchemaMSC
ViewMSC_ITEM_FCST_SR_LEVELS#