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

TABLE: MSC.MSC_BOD_SO_SR_LEVELS

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


This table stores hierarchy of sourcing for items that are part of Sales Orders.
This information is used internally to derive sources for Sales Orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_BOD_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 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
ALLOCATION_PERCENT NUMBER

Allocation Percent
RANK NUMBER

Rank
SHIP_METHOD VARCHAR2 (30)
Ship Method
EFFECTIVE_DATE DATE

Effective Date
DISABLE_DATE DATE

Disable Date
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
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
CUSTOMER_ID NUMBER

Customer Id
CUSTOMER_SITE_ID NUMBER

Customer Site Id
REGION_ID NUMBER

Region Id
REGION_TYPE NUMBER

Region Type
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
,      SHIP_METHOD
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SR_DESCRIPTION
,      COMPILE_DESIGNATOR
,      OWNING_ORG_ID
,      MRP_PLANNING_CODE
,      BOM_ITEM_TYPE
,      PLANNING_MAKE_BUY_CODE
,      PRIMARY_UOM_CODE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      REGION_TYPE
FROM MSC.MSC_BOD_SO_SR_LEVELS;

Dependencies

[top of page]

MSC.MSC_BOD_SO_SR_LEVELS does not reference any database object

MSC.MSC_BOD_SO_SR_LEVELS is referenced by following:

SchemaMSC
ViewMSC_BOD_SO_SR_LEVELS#