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_PROJ_COST_SUBLEDGER_V

Object Details

Object Name:	PA_PROJ_COST_SUBLEDGER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_COST_SUBLEDGER_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
EXPENDITURE_ITEM_ID	NUMBER	(15)	Expenditure item id
COST_DISTRIBUTION_LINE_NUM	NUMBER	(15)	Line number of the cost distribution line
CODE_COMBINATION_ID	NUMBER	(15)	SLA Account code combination id
ACCOUNT_DESCRIPTION	VARCHAR2	(240)	GL Account description
GL_DATE	DATE		GL transaction date
MFG_RELATED	VARCHAR2	(1)	Indicator (Y/N) as to whether costs are manufacturing related or not
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(80)	System linkage or expenditure type class code
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Expenditure category
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type
ORGANIZATION_ID	NUMBER	(15)	Organization id
PROJECT_TYPE	VARCHAR2	(20)	Project type
PROJECT_ID	NUMBER	(15)
PROJECT_NUMBER	VARCHAR2	(25)	Project number
PROJECT_NAME	VARCHAR2	(30)	Project name
TASK_ID	NUMBER	(15)
TASK_NUMBER	VARCHAR2	(25)	Task number
TASK_NAME	VARCHAR2	(20)	Task name
TOTAL_COST	NUMBER		Total cost in functional currency
RAW_COST	NUMBER		Raw cost in functional currency
BURDEN_COST	NUMBER		Burden cost in functional currency

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      COST_DISTRIBUTION_LINE_NUM
,      CODE_COMBINATION_ID
,      ACCOUNT_DESCRIPTION
,      GL_DATE
,      MFG_RELATED
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_CATEGORY
,      EXPENDITURE_TYPE
,      ORGANIZATION_ID
,      PROJECT_TYPE
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TOTAL_COST
,      RAW_COST
,      BURDEN_COST
FROM APPS.PA_PROJ_COST_SUBLEDGER_V;

Dependencies

[top of page]

APPS.PA_PROJ_COST_SUBLEDGER_V references the following:

APPS: GL_CODE_COMBINATIONS; GL_LEDGERS; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_IMPLEMENTATIONS_ALL; PA_PROJECTS_ALL; PA_SYSTEM_LINKAGES; PA_TASKS; PA_TRANSACTION_SOURCES; XLA_ACCT_CLASS_ASSGNS; XLA_AE_HEADERS; XLA_AE_LINES; XLA_ASSIGNMENT_DEFNS_B; XLA_DISTRIBUTION_LINKS; XLA_POST_ACCT_PROGS_B

APPS.PA_PROJ_COST_SUBLEDGER_V is referenced by following:

APPS: PA_PAXMGSLD_XMLP_PKG - show dependent code