[Home] [Help]
[Dependency Information]
VIEW: HR.PQP_EXCEPTION_REPORTS_EFC#
Object Details
Object Name: | PQP_EXCEPTION_REPORTS_EFC# |
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
EXCEPTION_REPORT_ID |
NUMBER |
(9) |
Yes |
|
EFC_ACTION_ID |
NUMBER |
|
Yes |
|
EFC_BG_CURRENCY |
VARCHAR2 |
(15) |
|
|
VARIANCE_VALUE |
NUMBER |
(11) |
|
|
CURRENCY_CODE |
VARCHAR2 |
(15) |
|
|
Query Text
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#;
Dependencies
[top of page]
HR.PQP_EXCEPTION_REPORTS_EFC# references the following:
-
HR
-
PQP_EXCEPTION_REPORTS_EFC
HR.PQP_EXCEPTION_REPORTS_EFC# is referenced by following:
-
APPS
-
PQP_EXCEPTION_REPORTS_EFC