DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_DR_EXCEPTIONS_DET_V

Object Details
Object Name: PA_DR_EXCEPTIONS_DET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_DR_EXCEPTIONS_DET_V
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PA_DR_EXCEPTIONS_DET_V references the following:

SchemaAPPS
ViewPA_DR_EXCEPTIONS_SUM_V
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
SynonymPA_PROJECTS_ALL

APPS.PA_DR_EXCEPTIONS_DET_V is not referenced by any database object