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

VIEW: APPS.PA_GL_DR_EXCEPT_DET_V

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

View Type

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


This view displays all 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
PROJECT_NUMBER VARCHAR2 (25) Yes Project Number
PROJECT_CURRENCY_CODE VARCHAR2 (15) Yes Project Currency Code
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
CORRECTION_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
,      PROJECT_NUMBER
,      PROJECT_CURRENCY_CODE
,      GL_DATE
,      PERIOD_NAME
,      AGREEMENT_ID
,      AMOUNT
,      TRANSFER_REJECTION_REASON
,      EXCEPTION_REASON
,      CORRECTION_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
FROM APPS.PA_GL_DR_EXCEPT_DET_V;

Dependencies

[top of page]

APPS.PA_GL_DR_EXCEPT_DET_V references the following:

SchemaAPPS
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
ViewPA_GL_DR_EXCEPT_SUM_V
SynonymPA_PROJECTS_ALL

APPS.PA_GL_DR_EXCEPT_DET_V is not referenced by any database object