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

VIEW: APPS.PA_GL_DR_EXCEPT_SUM_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view displays a summary of alll draft revenues that are yet to be transferred to accounts receivables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DRAFT_REVENUE_NUM NUMBER (15)
Draft Revenue Number
PROJECT_ID NUMBER (15)
Project Id
GL_DATE DATE

GL Date
PERIOD_NAME VARCHAR2 (15)
Period Name
AGREEMENT_ID NUMBER (15)
Agreement Id
AMOUNT NUMBER

Amount
TRANSFER_REJECTION_REASON VARCHAR2 (250)
Transfer Rejection Reason
EXCEPTION_REASON VARCHAR2 (4000)
Exception Reason
CORRECTIVE_ACTION VARCHAR2 (4000)
Corrective Action
ORG_ID NUMBER (15)
Operating Unit Identifier.
SAME_PA_GL_PERIOD VARCHAR2 (1)
Refer to base table.
OU_NAME VARCHAR2 (4000)
Operating Unit Name
SET_OF_BOOKS_ID NUMBER (15)
set of books identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DRAFT_REVENUE_NUM
,      PROJECT_ID
,      GL_DATE
,      PERIOD_NAME
,      AGREEMENT_ID
,      AMOUNT
,      TRANSFER_REJECTION_REASON
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
FROM APPS.PA_GL_DR_EXCEPT_SUM_V;

Dependencies

[top of page]

APPS.PA_GL_DR_EXCEPT_SUM_V references the following:

SchemaAPPS
SynonymGL_INTERFACE
SynonymGL_JE_CATEGORIES
SynonymGL_JE_SOURCES
SynonymGL_PERIOD_STATUSES
SynonymPA_DRAFT_REVENUES_ALL
SynonymPA_DRAFT_REVENUE_ITEMS
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
SynonymPA_IMPLEMENTATIONS_ALL
APPS.PA_GL_DR_EXCEPT_SUM_V is referenced by following:

SchemaAPPS
ViewPA_GL_DR_EXCEPT_DET_V