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]

TABLE: PA.PA_GL_REV_XFER_AUDIT_REP

Object Details

Object Name:	PA_GL_REV_XFER_AUDIT_REP
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_GL_REV_XFER_AUDIT_REP
Subobject Name:
Status:	VALID

Temporary table populated during Revenue Audit Report

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_GL_REV_XFER_AUDIT_REP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Comments
REQUEST_ID	NUMBER	(15)	Standard Who Column
CODE_COMBINATION_ID	NUMBER	(15)	The identifier of the gl account
LINE_TYPE	VARCHAR2	(9)	Identifies the type of the revenue line
PERIOD_NAME	VARCHAR2	(15)	The Period in which account is processed
PROJECT_ID	NUMBER	(15)	The identifier of the project for which the revenue is generated
PROJECT_NUMBER	VARCHAR2	(25)	Project number associated with the project
DRAFT_REV_NUMBER	NUMBER	(15)	The sequential number that identifies the draft revenue within a project
TRANSFERRED_DATE	DATE		The date that the draft revenue was transferred to General Ledger
GL_DATE	DATE		The end date of the GL accounting period to which to post the draft revenue transactions
TRANSACTION_TYPE	VARCHAR2	(30)	Identifies the type of revenue transaction
TRANSACTION_DATE	DATE		Identifies the date of transaction
TASK_ID	NUMBER		The identifier of the task of the revenue line
TASK_NUMBER	VARCHAR2	(25)	The identifier of the task number of the revenue line
EMP_OR_ORG_NAME	VARCHAR2	(240)	Identifies the employee or organization name
JE_BATCH_NAME	VARCHAR2	(100)
JE_BATCH_ID	NUMBER	(15)
JE_REP_BATCH_NAME	VARCHAR2	(100)
EXPENDITURE_ITEM_ID	NUMBER		The system-generated number that uniquely identifies the expenditure item
RDL_LINE_NUM	NUMBER		Identifies revenue distribution line number
RDL_EVENT_NUM	NUMBER		Identifies event number of the revenue distribution line
DEBIT_AMOUNT	NUMBER		Debit amount
CREDIT_AMOUNT	NUMBER		Credit amount

Query Text

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


SELECT REQUEST_ID
,      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
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_REP_BATCH_NAME
,      EXPENDITURE_ITEM_ID
,      RDL_LINE_NUM
,      RDL_EVENT_NUM
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
FROM PA.PA_GL_REV_XFER_AUDIT_REP;

Dependencies

[top of page]

PA.PA_GL_REV_XFER_AUDIT_REP does not reference any database object

PA.PA_GL_REV_XFER_AUDIT_REP is referenced by following:

APPS: PA_GL_REV_XFER_AUDIT_REP