eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_GL_REV_XFER_AUDIT_V

Object Details

Object Name:	PA_GL_REV_XFER_AUDIT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_GL_REV_XFER_AUDIT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
CODE_COMBINATION_ID	NUMBER	(15)	GL Account Code Combination Id
LINE_TYPE	VARCHAR2	(9)	Indicates whether the transaction is on a Revenue, Event Revenue, Unearned Revenue or Unbilled Receivables item
PERIOD_NAME	VARCHAR2	(15)	Period Name
PROJECT_ID	NUMBER	(15)	Project Id
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
DRAFT_REV_NUMBER	NUMBER	(15)	Draft Revenue Number
TRANSFERRED_DATE	DATE		The date on which this distribution was transferred to GL
GL_DATE	DATE		The end date of the accounting period to which this revenue is posted
TRANSACTION_TYPE	VARCHAR2	(30)	Event or Expenditure Type
TRANSACTION_DATE	DATE		Event Completion or Expenditure Item Date
TASK_ID	NUMBER		Task Id
TASK_NUMBER	VARCHAR2	(25)	Task Number
EMP_OR_ORG_NAME	VARCHAR2	(240)	Employee name or expenditure organization
EXPENDITURE_ITEM_ID	NUMBER		Expenditure Item Id
RDL_LINE_NUM	NUMBER		Line number of the expenditure or event revenue distribution line
RDL_EVENT_NUM	NUMBER
DEBIT_AMOUNT	NUMBER		Amount debited in this transaction
CREDIT_AMOUNT	NUMBER		Amount credited in this transaction

Query Text

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


SELECT CODE_COMBINATION_ID
,      LINE_TYPE
,      PERIOD_NAME
,      PROJECT_ID
,      PROJECT_NUMBER
,      DRAFT_REV_NUMBER
,      TRANSFERRED_DATE
,      GL_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TASK_ID
,      TASK_NUMBER
,      EMP_OR_ORG_NAME
,      EXPENDITURE_ITEM_ID
,      RDL_LINE_NUM
,      RDL_EVENT_NUM
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
FROM APPS.PA_GL_REV_XFER_AUDIT_V;

Dependencies

[top of page]

APPS.PA_GL_REV_XFER_AUDIT_V references the following:

APPS: GL_JE_BATCHES; GL_JE_HEADERS; GL_JE_LINES; GL_JE_SOURCES; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_CUST_EVENT_RDL_ALL; PA_CUST_REV_DIST_LINES_ALL; PA_DRAFT_REVENUES_ALL; PA_EVENTS; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_PROJECTS; PA_TASKS; PER_PEOPLE_F; XLA_AE_HEADERS; XLA_AE_LINES; XLA_DISTRIBUTION_LINKS

APPS.PA_GL_REV_XFER_AUDIT_V is not referenced by any database object