[Home] [Help] [Dependency Information]
Object Name: | QPR_PN_INT_PR_ADJS |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This interface table captures the erosions like on invoice adjustments and costs and offinvoice of a deal line from a source instance. The data is dumped to this table by specifying the source table/view and column mapping in qpr_measure_sources table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_PN_INT_PR_ADJS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PN_INT_PR_ADJ_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PN_INT_PR_ADJ_ID | NUMBER | Yes | Unique Identifier for the adjustment records | |
SOURCE_ID | NUMBER | Identifier of the deal line source. | ||
SOURCE_REF_HDR_ID | NUMBER | Yes | Header Id to which the deal line belongs in the source instance from which it is sourced. | |
SOURCE_REF_LINE_ID | NUMBER | Yes | Identifier of the deal line as in the source instance from which it is sourced. | |
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_INT_PR_ADJ_ID
, SOURCE_ID
, SOURCE_REF_HDR_ID
, SOURCE_REF_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_INT_PR_ADJS;
QPR.QPR_PN_INT_PR_ADJS does not reference any database object
QPR.QPR_PN_INT_PR_ADJS is referenced by following:
|
|
|