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

TABLE: MSC.MSC_ITEM_SO_SR_LEVELS

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


This table stores hierachy of sourcing for items which are part of Sales Orders. 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_SO_SR_LEVELS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item id
ORGANIZATION_ID NUMBER

Organization id
SR_INSTANCE_ID NUMBER

Source instance id of an 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's instance id
ALLOCATION_PERCENT NUMBER

Allocation percent
RANK NUMBER

Rank
EFFECTIVE_DATE DATE

Effective Date
DISABLE_DATE DATE

Disable date
SOURCING_LEVEL NUMBER

Sourcing level
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
SR_DESCRIPTION VARCHAR2 (80)
Sourcing rule description.
COMPILE_DESIGNATOR VARCHAR2 (10)
Plan name
OWNING_ORG_ID NUMBER

Owning organization id
COMP_MRP_PLANNING_CODE NUMBER

Component's MRP planning code
COMP_BOM_ITEM_TYPE NUMBER

Component's BOM item type
COMP_PLANNING_MAKE_BUY_CODE NUMBER

Component's planning Make/Buy code
COMP_PRIMARY_UOM_CODE VARCHAR2 (3)
Component's primary UOM code
CUSTOMER_ID NUMBER

Customer id
CUSTOMER_SITE_ID NUMBER

Customer site id
REGION_ID NUMBER

Region id
COMP_DRP_PLANNED NUMBER

Drp planned flag
Query Text

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


SELECT 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
,      ALLOCATION_PERCENT
,      RANK
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SR_DESCRIPTION
,      COMPILE_DESIGNATOR
,      OWNING_ORG_ID
,      COMP_MRP_PLANNING_CODE
,      COMP_BOM_ITEM_TYPE
,      COMP_PLANNING_MAKE_BUY_CODE
,      COMP_PRIMARY_UOM_CODE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      COMP_DRP_PLANNED
FROM MSC.MSC_ITEM_SO_SR_LEVELS;

Dependencies

[top of page]

MSC.MSC_ITEM_SO_SR_LEVELS does not reference any database object

MSC.MSC_ITEM_SO_SR_LEVELS is referenced by following:

SchemaMSC
ViewMSC_ITEM_SO_SR_LEVELS#