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_BURDEN_EXP_ITEM_CDL_V

Object Details

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

View Type

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

This View lists all the summarized burden expenditure items and their cost distribution lines.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_TYPE	VARCHAR2	(20)	Yes	Project type of the project to which the summarized burden expenditure item and CDLs belongs to
SEGMENT1	VARCHAR2	(25)	Yes	Project Number of the project to which the summarized burden expenditure item and CDLs belongs to
TASK_NUMBER	VARCHAR2	(25)	Yes	task Number of the project to which the summarized burden expenditure item and CDLs belongs to
PA_DATE	DATE			Account closing date of the summarized burden expenditure item
ATTRIBUTE1	VARCHAR2	(150)		Attribute1 of summarized burden expenditure item \ this field is used in GMS to store the sponsoring award id of the task/project
EXPENDITURE_GROUP	VARCHAR2	(240)	Yes	Expenditure group associated with the Summarized burden expenditure item
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	expenditure item type of the summarized burden expenditure item. This will be same as the \ expenditure type associated with the burden cost code
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	expenditure_item_id of summarized burden expenditure item
LINE_NUM	NUMBER	(15)	Yes	Line number of the CDL of summarized burden expenditure item
EXPENDITURE_ITEM_DATE	DATE		Yes	Date of creation of summarized burden expenditure item.
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)		run_id of the burden summarization program responsible for the creation of the summarized burden expenditure item.
ORG_ID	NUMBER	(15)	Yes	Operating Unit Identifier

Query Text

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


SELECT PROJECT_TYPE
,      SEGMENT1
,      TASK_NUMBER
,      PA_DATE
,      ATTRIBUTE1
,      EXPENDITURE_GROUP
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      EXPENDITURE_ITEM_DATE
,      BURDEN_SUM_SOURCE_RUN_ID
,      ORG_ID
FROM APPS.PA_BURDEN_EXP_ITEM_CDL_V;

Dependencies

[top of page]

APPS.PA_BURDEN_EXP_ITEM_CDL_V references the following:

APPS: PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURES; PA_EXPENDITURE_ITEMS_ALL; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL; PA_TASKS

APPS.PA_BURDEN_EXP_ITEM_CDL_V is not referenced by any database object