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_CDL_BURDEN_SUM_ERROR_V

Object Details

Object Name:	PA_CDL_BURDEN_SUM_ERROR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CDL_BURDEN_SUM_ERROR_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	Mandatory	Comments
PROJECT_TYPE	VARCHAR2	(20)	Yes	Project type of the project to which the CDL having error while burden summarization belongs to
PROJECT_ID	NUMBER	(15)	Yes	Project id to which the CDL having error while burden summarization belongs to
SEGMENT1	VARCHAR2	(25)	Yes	Project Number to which the CDL having error while burden summarization belongs to
TASK_ID	NUMBER	(15)	Yes	task to which the CDL having error while burden summarization belongs to
TASK_NUMBER	VARCHAR2	(25)	Yes	task Number to which the CDL having error while burden summarization belongs to
ATTRIBUTE1	VARCHAR2	(150)		Attribute1 to which the CDL having error while burden summarization belongs to \ this field is used in GMS to store the sponsoring award id of the task/project
EI_EXP_TYPE	VARCHAR2	(30)	Yes	expenditure item type of the expenditure item id to which the CDL having error while burden summarization belongs to
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	expenditure item id to which the CDL having error while burden summarization belongs to
LINE_NUM	NUMBER	(15)	Yes	Line number of the CDL having error while burden summarization belongs to
PA_DATE	DATE			Account closing date of CDL having error while burden summarization belongs to
EXPENDITURE_ITEM_DATE	DATE		Yes	date of expenditure item of the CDL having error while burden summarization belongs to
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)		run id of the summarization process which identified the error CDL
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)		rejection reason code identified during the burden summarization processs. The Error CDLs 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 CDL in error
DESCRIPTION	VARCHAR2	(240)		Detailed description of the the rejection error code of the CDL in error
ORG_ID	NUMBER	(15)

Query Text

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


SELECT PROJECT_TYPE
,      PROJECT_ID
,      SEGMENT1
,      TASK_ID
,      TASK_NUMBER
,      ATTRIBUTE1
,      EI_EXP_TYPE
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      PA_DATE
,      EXPENDITURE_ITEM_DATE
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      MEANING
,      DESCRIPTION
,      ORG_ID
FROM APPS.PA_CDL_BURDEN_SUM_ERROR_V;

Dependencies

[top of page]

APPS.PA_CDL_BURDEN_SUM_ERROR_V references the following:

APPS: PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL; PA_TASKS

APPS.PA_CDL_BURDEN_SUM_ERROR_V is not referenced by any database object