[Home] [Help] [Dependency Information]
Object Name: | MSD_PRICE_LIST |
---|---|
Object Type: | TABLE |
Owner: | MSD |
FND Design Data: | MSD.MSD_PRICE_LIST |
Subobject Name: | |
Status: | VALID |
This table has Price Lists.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSD_PRICE_LIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PRICE_LIST_NAME
START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE | VARCHAR2 | (40) | Yes | Instance |
ORGANIZATION_LVL_ID | NUMBER | Organization Lvl Id | ||
SR_ORGANIZATION_LVL_PK | VARCHAR2 | (240) | Sr Organization Lvl Pk | |
PRODUCT_LVL_ID | NUMBER | Product Lvl Id | ||
SR_PRODUCT_LVL_PK | VARCHAR2 | (240) | Sr Product Lvl Pk | |
SALESCHANNEL_LVL_ID | NUMBER | Saleschannel Lvl Id | ||
SR_SALESCHANNEL_LVL_PK | VARCHAR2 | (240) | Sr Saleschannel Lvl Pk | |
SALES_REP_LVL_ID | NUMBER | Sales Rep Lvl Id | ||
SR_SALES_REP_LVL_PK | VARCHAR2 | (240) | Sr Sales Rep Lvl Pk | |
GEOGRAPHY_LVL_ID | NUMBER | Geography Lvl Id | ||
SR_GEOGRAPHY_LVL_PK | VARCHAR2 | (240) | Sr Geography Lvl Pk | |
USER_DEFINED1_LVL_ID | NUMBER | User Defined1 Lvl Id | ||
SR_USER_DEFINED1_LVL_PK | VARCHAR2 | (240) | Sr User Defined1 Lvl Pk | |
USER_DEFINED2_LVL_ID | NUMBER | User Defined2 Lvl Id | ||
SR_USER_DEFINED2_LVL_PK | VARCHAR2 | (240) | Sr User Defined2 Lvl Pk | |
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 | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
REQUEST_ID | NUMBER | Request Id | ||
PROGRAM_APPLICATION_ID | NUMBER | Program Application Id | ||
PROGRAM_ID | NUMBER | Program Id | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date | ||
LAST_REFRESH_NUM | NUMBER | Last refresh number | ||
CREATED_BY_REFRESH_NUM | NUMBER | created by refresh number | ||
ACTION_CODE | VARCHAR2 | (30) | DML action code | |
DEMAND_CLASS_LVL_ID | NUMBER | Demand Class Level ID | ||
SR_DEMAND_CLASS_LVL_PK | VARCHAR2 | (240) | Source Demand Class Code |
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
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, DEMAND_CLASS_LVL_ID
, SR_DEMAND_CLASS_LVL_PK
FROM MSD.MSD_PRICE_LIST;
MSD.MSD_PRICE_LIST does not reference any database object
MSD.MSD_PRICE_LIST is referenced by following:
|
|
|