[Home] [Help] [Dependency Information]
Object Name: | QPR_PN_PR_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table stores the different erosions like on invoice adjustments, costs and off-invoice adjustments per deal response. The cost and on invoice information comes from the interface table but the off-invoice information is derived from the data mart. Enteries are present per erosion type per deal line. The number of adjustment modifiers per erosion type differs based on the data extracted from source. A rolled up header level value is also present.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_PN_PR_DETAILS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PN_PR_DETAIL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PN_PR_DETAIL_ID | NUMBER | Yes | Unique Identifier | |
RESPONSE_HEADER_ID | NUMBER | Yes | Unique identifier of the deal response header to which the details belong. | |
PN_LINE_ID | NUMBER | Unique Identifier of the deal line to which the details belong. | ||
EROSION_TYPE | VARCHAR2 | (30) | Yes | Indicates the type of erosion. Values are 'ONINVOICE', 'COST' and 'OFFINVOICE'. |
EROSION_NAME | VARCHAR2 | (240) | Identifier of the adjustment modifiers. | |
EROSION_DESC | VARCHAR2 | (240) | Description of the adjustment modifiers. | |
EROSION_PER_UNIT | NUMBER | The erosion value per unit | ||
EROSION_AMOUNT | NUMBER | Total Erosion Amount | ||
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_DETAIL_ID
, RESPONSE_HEADER_ID
, PN_LINE_ID
, EROSION_TYPE
, EROSION_NAME
, EROSION_DESC
, EROSION_PER_UNIT
, EROSION_AMOUNT
, 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_DETAILS;
QPR.QPR_PN_PR_DETAILS does not reference any database object
QPR.QPR_PN_PR_DETAILS is referenced by following:
|
|
|