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_CC_GL_COST_XFER_AUDIT_V

Object Details

Object Name:	PA_CC_GL_COST_XFER_AUDIT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CC_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 cross charge transactions in Oracle Projects for both GL Categories (Borrowed and Lent category and Provider Cost Reclass category) and the corresponding GL Journal Entry batch numbers and period into which these transactions were posted. It provides audit between accounting (cross charge cost) transactions in Oracle Projects and transactions in Oracle General Ledger.

[View Source]

Columns

Name	Datatype	Length	Comments
CC_DIST_LINE_ID	NUMBER		Cross Charge Distribution Line Id
CC_DIST_LINE_TYPE	VARCHAR2	(2)	Cross Charge Distribution Line Type
EXPENDITURE_ITEM_ID	NUMBER	(15)	Expenditure Item Id
CC_DIST_LINE_NUM	NUMBER		Cross Charge 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_HEADER_ID	NUMBER	(15)	SLA Journal Entry Header Defining Column
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

Query Text

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


SELECT CC_DIST_LINE_ID
,      CC_DIST_LINE_TYPE
,      EXPENDITURE_ITEM_ID
,      CC_DIST_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_HEADER_ID
,      JE_LINE_NUMBER
,      GL_DATE
,      TRANSFERRED_DATE
,      GL_DR_AMOUNT
,      GL_CR_AMOUNT
FROM APPS.PA_CC_GL_COST_XFER_AUDIT_V;

Dependencies

[top of page]

APPS.PA_CC_GL_COST_XFER_AUDIT_V references the following:

APPS: GL_IMPORT_REFERENCES; GL_JE_HEADERS; GL_JE_LINES; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_CC_DIST_LINES_ALL; PA_EXPENDITURES; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_IMPLEMENTATIONS; PA_PROJECTS_ALL; 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_CC_GL_COST_XFER_AUDIT_V is not referenced by any database object