[Home] [Help] [Dependency Information]
Object Name: | PA_DR_EXCEPTIONS_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_DR_EXCEPTIONS_DET_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_DR_EXCEPTIONS_DET_V is a view that identifies the Draft Revenues that prevent a period from being closed.
.
It returns detail information on specific draft revenues that have not been interfaced to GL and therefore are preventing the PA Period from being close
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAFT_REVENUE_NUM | NUMBER | (15) | Refer to the base table | |
PROJECT_ID | NUMBER | (15) | Refer to the base table | |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Refer to the base table |
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Project Currency Code |
PA_DATE | DATE | Refer to the base table | ||
PERIOD_NAME | VARCHAR2 | (20) | Refer to the base table | |
AGREEMENT_ID | NUMBER | (15) | Refer to the base table | |
AMOUNT | NUMBER | Refer to the base table | ||
TRANSFER_REJECTION_REASON | VARCHAR2 | (250) | Refer to the base table | |
EXCEPTION_REASON | VARCHAR2 | (4000) | Refer to the base table | |
CORRECTION_ACTION | VARCHAR2 | (4000) | Refer to the base table |
Cut, paste (and edit) the following text to query this object:
SELECT DRAFT_REVENUE_NUM
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_CURRENCY_CODE
, PA_DATE
, PERIOD_NAME
, AGREEMENT_ID
, AMOUNT
, TRANSFER_REJECTION_REASON
, EXCEPTION_REASON
, CORRECTION_ACTION
FROM APPS.PA_DR_EXCEPTIONS_DET_V;
APPS.PA_DR_EXCEPTIONS_DET_V is not referenced by any database object
|
|
|