[Home] [Help] [Dependency Information]
Object Name: | PQP_EXCEPTION_REPORTS_EFC |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
EFC table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_EXCEPTION_REPORTS_EFC_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EXCEPTION_REPORT_ID
EFC_ACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCEPTION_REPORT_ID | NUMBER | (9) | Yes | System generated primary key column |
EFC_ACTION_ID | NUMBER | Yes | System generated primary key column | |
EFC_BG_CURRENCY | VARCHAR2 | (15) | Efc Businessgroup curreny code. | |
VARIANCE_VALUE | NUMBER | (11) | The variance value defined for the exception report. | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the record. |
Cut, paste (and edit) the following text to query this object:
SELECT EXCEPTION_REPORT_ID
, EFC_ACTION_ID
, EFC_BG_CURRENCY
, VARIANCE_VALUE
, CURRENCY_CODE
FROM HR.PQP_EXCEPTION_REPORTS_EFC;
HR.PQP_EXCEPTION_REPORTS_EFC does not reference any database object
HR.PQP_EXCEPTION_REPORTS_EFC is referenced by following:
|
|
|