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

TABLE: MSD.MSD_ST_PRICE_LIST

Object Details
Object Name: MSD_ST_PRICE_LIST
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_ST_PRICE_LIST
Subobject Name:
Status: VALID


Staging table for price list data


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_ST_PRICE_LIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINSTANCE
ColumnPRICE_LIST_NAME
ColumnSR_PRODUCT_LVL_PK
ColumnSTART_DATE
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40)
Source instance id
ORGANIZATION_LVL_ID NUMBER

Organization level id
SR_ORGANIZATION_LVL_PK VARCHAR2 (240)
Organization level source primary key
PRODUCT_LVL_ID NUMBER

Product level id
SR_PRODUCT_LVL_PK VARCHAR2 (240)
Product level source primary key
SALESCHANNEL_LVL_ID NUMBER

Sales channel level id
SR_SALESCHANNEL_LVL_PK VARCHAR2 (240)
Sales Channel source primary key
SALES_REP_LVL_ID NUMBER

Sales rep level id
SR_SALES_REP_LVL_PK VARCHAR2 (240)
Sales Representative source primary key
GEOGRAPHY_LVL_ID NUMBER

Geography level id
SR_GEOGRAPHY_LVL_PK VARCHAR2 (240)
Geography source primary key
USER_DEFINED1_LVL_ID NUMBER

User defined dimension 1 level id
SR_USER_DEFINED1_LVL_PK VARCHAR2 (240)
User Defined dimension 1 source primary key
USER_DEFINED2_LVL_ID NUMBER

User defined dimension 2 level id
SR_USER_DEFINED2_LVL_PK VARCHAR2 (240)
User Defined dimension 2 source primary key
PRICE_LIST_NAME VARCHAR2 (240)
Price List Name
START_DATE DATE

Start Date
END_DATE DATE

End Date
PRICE NUMBER

Price
PRIORITY NUMBER

Priority
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Concurrent Who Column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who Column
PROGRAM_ID NUMBER

Concurrent Who Column
PROGRAM_UPDATE_DATE DATE

Concurrent Who Column
ORGANIZATION_LVL VARCHAR2 (30)
Organization Level Name
SR_ORGANIZATION_LVL_VAL VARCHAR2 (240)
Organization level value
PRODUCT_LVL VARCHAR2 (30)
Product level name
SR_PRODUCT_LVL_VAL VARCHAR2 (240)
Product level value
SALESCHANNEL_LVL VARCHAR2 (30)
Sales channel level name
SR_SALESCHANNEL_LVL_VAL VARCHAR2 (240)
Sales channel level value
SALES_REP_LVL VARCHAR2 (30)
Sales Representative level name
SR_SALES_REP_LVL_VAL VARCHAR2 (240)
Sales Representative level value
GEOGRAPHY_LVL VARCHAR2 (30)
Geography level name
SR_GEOGRAPHY_LVL_VAL VARCHAR2 (240)
Geography level value
USER_DEFINED1_LVL VARCHAR2 (30)
User defined dimension 1 level name
SR_USER_DEFINED1_LVL_VAL VARCHAR2 (240)
User define dimension 1 level value
USER_DEFINED2_LVL VARCHAR2 (30)
User define dimension 2 level name
SR_USER_DEFINED2_LVL_VAL VARCHAR2 (240)
User define dimension 2 level value
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance code
PROCESS_FLAG NUMBER

This is an internal column. It is populated and used by Legacy Collection Process.
DATA_SOURCE_TYPE VARCHAR2 (15)
This is an internal column. It is populated and used by Legacy Collection Process.
BATCH_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process.
ST_TRANSACTION_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process.
ERROR_TEXT VARCHAR2 (2000)
This is an internal column. It is populated and used by Legacy Collection Process.
MESSAGE_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process.
DEMAND_CLASS_LVL_ID NUMBER

Demand Class Level ID
SR_DEMAND_CLASS_LVL_PK VARCHAR2 (240)
Source Demand Class Code
SR_DEMAND_CLASS_LVL_VAL VARCHAR2 (240)
Demand Class Level Value
DEMAND_CLASS_LVL VARCHAR2 (240)
Demand Class Level Value
PRIMARY_UOM_FLAG VARCHAR2 (3)
Primary UOM Flag
PRICE_LIST_UOM VARCHAR2 (30)
Price List UOM
VALID_FLAG NUMBER

Valid Flag
Query Text

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


SELECT INSTANCE
,      ORGANIZATION_LVL_ID
,      SR_ORGANIZATION_LVL_PK
,      PRODUCT_LVL_ID
,      SR_PRODUCT_LVL_PK
,      SALESCHANNEL_LVL_ID
,      SR_SALESCHANNEL_LVL_PK
,      SALES_REP_LVL_ID
,      SR_SALES_REP_LVL_PK
,      GEOGRAPHY_LVL_ID
,      SR_GEOGRAPHY_LVL_PK
,      USER_DEFINED1_LVL_ID
,      SR_USER_DEFINED1_LVL_PK
,      USER_DEFINED2_LVL_ID
,      SR_USER_DEFINED2_LVL_PK
,      PRICE_LIST_NAME
,      START_DATE
,      END_DATE
,      PRICE
,      PRIORITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORGANIZATION_LVL
,      SR_ORGANIZATION_LVL_VAL
,      PRODUCT_LVL
,      SR_PRODUCT_LVL_VAL
,      SALESCHANNEL_LVL
,      SR_SALESCHANNEL_LVL_VAL
,      SALES_REP_LVL
,      SR_SALES_REP_LVL_VAL
,      GEOGRAPHY_LVL
,      SR_GEOGRAPHY_LVL_VAL
,      USER_DEFINED1_LVL
,      SR_USER_DEFINED1_LVL_VAL
,      USER_DEFINED2_LVL
,      SR_USER_DEFINED2_LVL_VAL
,      SR_INSTANCE_CODE
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      MESSAGE_ID
,      DEMAND_CLASS_LVL_ID
,      SR_DEMAND_CLASS_LVL_PK
,      SR_DEMAND_CLASS_LVL_VAL
,      DEMAND_CLASS_LVL
,      PRIMARY_UOM_FLAG
,      PRICE_LIST_UOM
,      VALID_FLAG
FROM MSD.MSD_ST_PRICE_LIST;

Dependencies

[top of page]

MSD.MSD_ST_PRICE_LIST does not reference any database object

MSD.MSD_ST_PRICE_LIST is referenced by following:

SchemaMSD
ViewMSD_ST_PRICE_LIST#