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

TABLE: MSC.MSC_ITEM_FCST_BOD_SR_LEVELS

Object Details
Object Name: MSC_ITEM_FCST_BOD_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 sources for global forecast.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ITEM_FCST_BOD_SR_LEVELS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnSR_INVENTORY_ITEM_ID
ColumnASSIGNMENT_TYPE
ColumnORGANIZATION_ID
MSC_ITEM_FCST_BOD_SR_LEVELS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnSR_INVENTORY_ITEM_ID
ColumnASSIGNMENT_TYPE
ColumnZONE_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 for Organization
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
SHIP_METHOD VARCHAR2 (30)
Ship method
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 orgnization code
SR_DESCRIPTION VARCHAR2 (80)
Sourcing rule description
OWNING_ORG_ID NUMBER

Owning Organization Id
CUSTOMER_ID NUMBER

Customer Id
CUSTOMER_SITE_ID NUMBER

Customer site id
ZONE_ID NUMBER

Zone id
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
,      SHIP_METHOD
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      CATEGORY_ID
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SOURCE_ORG_CODE
,      SR_DESCRIPTION
,      OWNING_ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ZONE_ID
FROM MSC.MSC_ITEM_FCST_BOD_SR_LEVELS;

Dependencies

[top of page]

MSC.MSC_ITEM_FCST_BOD_SR_LEVELS does not reference any database object

MSC.MSC_ITEM_FCST_BOD_SR_LEVELS is referenced by following:

SchemaMSC
ViewMSC_ITEM_FCST_BOD_SR_LEVELS#