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_SUM_ERROR_V

Object Details

Object Name:	PA_CMT_BURDEN_SUM_ERROR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CMT_BURDEN_SUM_ERROR_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 Commitment transactions which are in error during burden summarization.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_TYPE	VARCHAR2	(20)	Yes	Project type of the project to which the commitment transaction belongs to
PROJECT_ID	NUMBER	(15)	Yes	Project id to which the commitment transaction belongs to
SEGMENT1	VARCHAR2	(25)	Yes	Project Number to which the commitment transaction belongs to
TASK_ID	NUMBER	(15)	Yes	Task to which the commitment transaction
TASK_NUMBER	VARCHAR2	(25)	Yes	Task Number to which the commitment transaction
PA_PERIOD	VARCHAR2	(20)	Yes	Account closing date of commitment transaction
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes	Transaction source of the commitment transaction in error
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure item type of the commitment transaction
LINE_TYPE	VARCHAR2	(1)	Yes	Line type of the commitment transaction in error
CMT_NUMBER	VARCHAR2	(240)		Commitment reference number of the commitment transaction
EXPENDITURE_ITEM_DATE	DATE		Yes	date of expenditure item of the CDL having error while burden summarization belongs to
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(30)		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
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)		Run id of the summarization process which identified the error commitment transaction
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)		Rejection reason code identified during the burden summarization processs. The Error identified for the commitment transaction would have to be corrected before it is picked up for summarization next time
MEANING	VARCHAR2	(80)	Yes	Meaning of the rejection error code of the commitment transaction in error
DESCRIPTION	VARCHAR2	(240)		Detailed description of the the rejection error code of the commitment transaction in error

Query Text

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


SELECT PROJECT_TYPE
,      PROJECT_ID
,      SEGMENT1
,      TASK_ID
,      TASK_NUMBER
,      PA_PERIOD
,      TRANSACTION_SOURCE
,      EXPENDITURE_TYPE
,      LINE_TYPE
,      CMT_NUMBER
,      EXPENDITURE_ITEM_DATE
,      ORIGINAL_TXN_REFERENCE1
,      ORIGINAL_TXN_REFERENCE2
,      ORIGINAL_TXN_REFERENCE3
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      MEANING
,      DESCRIPTION
FROM APPS.PA_CMT_BURDEN_SUM_ERROR_V;

Dependencies

[top of page]

APPS.PA_CMT_BURDEN_SUM_ERROR_V references the following:

APPS: PA_COMMITMENT_TXNS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL; PA_TASKS

APPS.PA_CMT_BURDEN_SUM_ERROR_V is not referenced by any database object