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_COST_XFER_AUDIT_V

Object Details

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

View Type

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

This view shows the cost transactions in Oracle Projects and the corresponding GL Journal Entry batch numbers and period into which these transactions were posted.

[View Source]

Columns

Name	Datatype	Length	Comments
EXPENDITURE_ITEM_ID	NUMBER	(15)	Expenditure Item Id
CDL_LINE_NUM	NUMBER	(15)	Cost Distribution Line Number
CODE_COMBINATION_ID	NUMBER	(15)	Account Code Combination Id
PROJECT_ID	NUMBER	(15)	Project Id
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
TASK_ID	NUMBER	(15)	Task Id
TASK_NUMBER	VARCHAR2	(25)	Task Number
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure Type
EXPENDITURE_ITEM_DATE	DATE		Expenditure Item Date
EMP_OR_ORG_NAME	VARCHAR2	(240)	Employee name or organization name
PERIOD_NAME	VARCHAR2	(15)	SLA Journal Entry Period
JE_LINE_NUMBER	NUMBER	(15)	SLA Journal Entry Line Number
GL_DATE	DATE		The end date of the accounting period to which this cost is posted
TRANSFERRED_DATE	DATE		The date on which this distribution was transferred to SLA
GL_DR_AMOUNT	NUMBER		Amount debited in this transaction
GL_CR_AMOUNT	NUMBER		Amount credited in this transaction
CR_CODE_COMBINATION_ID	NUMBER		The identifier of the SLA liability account
ORG_ID	NUMBER	(15)

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      CDL_LINE_NUM
,      CODE_COMBINATION_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      EMP_OR_ORG_NAME
,      PERIOD_NAME
,      JE_LINE_NUMBER
,      GL_DATE
,      TRANSFERRED_DATE
,      GL_DR_AMOUNT
,      GL_CR_AMOUNT
,      CR_CODE_COMBINATION_ID
,      ORG_ID
FROM APPS.PA_GL_COST_XFER_AUDIT_V;

Dependencies

[top of page]

APPS.PA_GL_COST_XFER_AUDIT_V references the following:

APPS: GL_IMPORT_REFERENCES; GL_JE_HEADERS; GL_JE_LINES; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURES; PA_EXPENDITURE_ITEMS_ALL; PA_IMPLEMENTATIONS; PA_PROJECTS_ALL; PA_SYSTEM_LINKAGES; PA_TASKS; PER_PEOPLE_F; XLA_ACCT_CLASS_ASSGNS; XLA_AE_HEADERS; XLA_AE_LINES; XLA_ASSIGNMENT_DEFNS_B; XLA_DISTRIBUTION_LINKS; XLA_POST_ACCT_PROGS_B

APPS.PA_GL_COST_XFER_AUDIT_V is not referenced by any database object