[Home] [Help] [Dependency Information]
Object Name: | QPR_PN_PR_TYPES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table stores the metadata for the price types (examples are Selling Price, Pocket Price, margin etc ) and, from and how to derive this.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_PN_PR_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PN_PR_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PN_PR_TYPE_ID | NUMBER | Yes | Unique Identifier of the price type | |
PRICE_TYPE_NAME | VARCHAR2 | (30) | Yes | Name of the type like 'Selling Price', 'List Price', 'Pocket Price' and 'Pocket Margin'. |
SEQUENCE_NO | NUMBER | Yes | Indicates the order in which the prices will be derived from the base price. Also indicates the order in which the price will be rendered in the waterfall graph. | |
COLUMN_NAME | VARCHAR2 | (30) | Indicates the line interface table column from which a price can be sourced. Only the 'LISTPRICE' has this column filled. Other prices are derived from the base list price. | |
DERIVED_FROM_TYPE | VARCHAR2 | (30) | Indicates the price type from which the given price type is dervied. | |
EROSION_TYPE | VARCHAR2 | (30) | Indicates the erosion type to be applied to 'derived_from_type' to get the given price. | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applicaitons Concurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the concurrent program | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT PN_PR_TYPE_ID
, PRICE_TYPE_NAME
, SEQUENCE_NO
, COLUMN_NAME
, DERIVED_FROM_TYPE
, EROSION_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_PN_PR_TYPES;
QPR.QPR_PN_PR_TYPES does not reference any database object
QPR.QPR_PN_PR_TYPES is referenced by following:
|
|
|