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_CMT_BURDEN_TXN_V

Object Details

Object Name:	PA_CMT_BURDEN_TXN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CMT_BURDEN_TXN_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 Commitment transactions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_TYPE	VARCHAR2	(20)	Yes	Project type of the summarized burden commitment transaction
SEGMENT1	VARCHAR2	(25)	Yes	Project Number of ummarized burdenommitment transaction
TASK_NUMBER	VARCHAR2	(25)	Yes	Task Number of summarized burden commitment transaction
PA_PERIOD	VARCHAR2	(20)	Yes	Account closing date of summarized burden commitment transaction
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes	Transaction source of the summarized burden commitment transaction
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type of the summarized burden commitment transaction. This will be same as the expenditure type associated with the burden cost code
EXPENDITURE_ITEM_DATE	DATE		Yes	Date of creation of summarized burden commitment transaction.
LINE_TYPE	VARCHAR2	(1)	Yes	Line type of the summarized burden commitment transaction
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(15)		Transaction reference1 the commitment transaction. This is customizable field. This field is used in GMS to store the sponsoring award id of the task/project
ORIGINAL_TXN_REFERENCE2	VARCHAR2	(15)		Transaction reference2 the commitment transaction. This is customizable field
ORIGINAL_TXN_REFERENCE3	VARCHAR2	(15)		Transaction reference3 the commitment transaction. This is customizable field
TOT_CMT_BURDENED_COST	NUMBER			Total commitment burden cost

Query Text

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


SELECT PROJECT_TYPE
,      SEGMENT1
,      TASK_NUMBER
,      PA_PERIOD
,      TRANSACTION_SOURCE
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      LINE_TYPE
,      ORIGINAL_TXN_REFERENCE1
,      ORIGINAL_TXN_REFERENCE2
,      ORIGINAL_TXN_REFERENCE3
,      TOT_CMT_BURDENED_COST
FROM APPS.PA_CMT_BURDEN_TXN_V;

Dependencies

[top of page]

APPS.PA_CMT_BURDEN_TXN_V references the following:

APPS: PA_COMMITMENT_TXNS; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL; PA_TASKS

APPS.PA_CMT_BURDEN_TXN_V is not referenced by any database object