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

TABLE: MSC.MSC_ST_PRICE_LIST

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ITEM_NAME VARCHAR2 (40)
Item Name
PRICE_LIST_NAME VARCHAR2 (40)
Price List Name
START_DATE DATE

Start Date for Price
END_DATE DATE

End Date for Price
PRICE NUMBER

Price of the Item
PRIORITY NUMBER

Priority of the Price
PRIMARY_UOM_FLAG VARCHAR2 (1)
Primary UOM Flag
PRODUCT_UOM_CODE VARCHAR2 (3)
Item UOM Code
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary UOM Code
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
Query Text

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


SELECT ITEM_NAME
,      PRICE_LIST_NAME
,      START_DATE
,      END_DATE
,      PRICE
,      PRIORITY
,      PRIMARY_UOM_FLAG
,      PRODUCT_UOM_CODE
,      PRIMARY_UOM_CODE
,      SR_INSTANCE_CODE
FROM MSC.MSC_ST_PRICE_LIST;

Dependencies

[top of page]

MSC.MSC_ST_PRICE_LIST does not reference any database object

MSC.MSC_ST_PRICE_LIST is referenced by following:

SchemaMSC
ViewMSC_ST_PRICE_LIST#