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

TABLE: MSD.MSD_ST_ITEM_LIST_PRICE

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


This is the staging table for the item information like the base UOM, list price, and average discount.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes Source instance ID.
ITEM VARCHAR2 (320)
Item name.
LIST_PRICE NUMBER

Item list price.
AVG_DISCOUNT NUMBER

Average discount for the item.
BASE_UOM VARCHAR2 (3)
Base unit of measure for the item.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_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.
SR_ITEM_PK VARCHAR2 (240) Yes Primary key for item.
ITEM_TYPE_ID NUMBER

BOM Item Type
FORECAST_TYPE_ID NUMBER

ATO Forecast Control Type
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
PROCESS_FLAG NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
DATA_SOURCE_TYPE VARCHAR2 (15)
This is an internal column. It is pouplate and used by Legacy Collection process.
ST_TRANSACTION_ID NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
BATCH_ID NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
ERROR_TEXT VARCHAR2 (2000)
This is an internal column. It is pouplate and used by Legacy Collection process.
Query Text

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


SELECT INSTANCE
,      ITEM
,      LIST_PRICE
,      AVG_DISCOUNT
,      BASE_UOM
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_ITEM_PK
,      ITEM_TYPE_ID
,      FORECAST_TYPE_ID
,      SR_INSTANCE_CODE
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      ERROR_TEXT
FROM MSD.MSD_ST_ITEM_LIST_PRICE;

Dependencies

[top of page]

MSD.MSD_ST_ITEM_LIST_PRICE does not reference any database object

MSD.MSD_ST_ITEM_LIST_PRICE is referenced by following:

SchemaMSD
ViewMSD_ST_ITEM_LIST_PRICE#