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_DETAIL_V

Object Details

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

View Type

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

This view displays all the burden components of the CDLs for a project. The project must be set in pa_cost_plus_extn1.current_project_id

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)	Project id of the cost distribution line item whose burden components are being summarized
TASK_ID	NUMBER	(15)	task id of the cost distribution line item whose burden components are being summarized
ORGANIZATION_ID	NUMBER		Organization actually incurred the expenses or the overriding organization of an expenditure item
PA_DATE	DATE		Account period end date of an expenditure item
PA_PERIOD_NAME	VARCHAR2	(4000)	Account period name of an expenditure item
ATTRIBUTE1	VARCHAR2	(150)	Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE2	VARCHAR2	(150)	Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE3	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE4	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE5	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE6	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE7	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE8	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE9	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE10	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Flex field used for customization
PERSON_TYPE	VARCHAR2	(30)	Type of person who incurred the expenditure
PO_LINE_ID	NUMBER		Purchase order line identifier for imported contingent worker labor transactions
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	System Linkage Function of the Expenditure Item
IND_COST_CODE	VARCHAR2	(30)	Indirect cost code associated with the expenditure type of an expenditure item
EI_EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type of an expenditure item
ICC_EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type of the indirect cost code associated with an expenditure item. Each indirect cost code may be associated with one expenditure type
COST_BASE	VARCHAR2	(30)	Cost base code of the expenditure item
COMPILED_MULTIPLIER	NUMBER	(22)	Indicative code for applying the indirect cost multiplication factors for the CDL for each burden cost code of the CDL
IND_COMPILED_SET_ID	NUMBER	(15)
EXPENDITURE_ITEM_ID	NUMBER	(15)	Identifier of the expenditure item being used for burden summarization
LINE_NUM	NUMBER	(15)	Line item number of the CDL of an expenditure item
EXPENDITURE_ITEM_DATE	DATE		Date of creation of the line_item
BURDEN_COST	NUMBER		Total burden cost of the CDL (In Project Currency)
DENOM_BURDENED_COST	NUMBER		Total burden cost of the CDL (In Denomination Currency)
ACCT_BURDENED_COST	NUMBER		Total burden cost of the CDL (In Acct Currency)
PROJECT_BURDENED_COST	NUMBER		Burdened cost in project currency
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)	Unique number identifying the run of a burden summarization process. All the CDLs processed,summarized burden \ expenditure items created during a run are stamped with one run id fro sequence pa_burden_sum_run_id_s
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)	Code identifies the rejection reason for a CDL during summarization. Rejected CDLs can be corrected for the \ error and they will be summarized in the susequent run
SYSTEM_REFERENCE1	VARCHAR2	(30)	For Supplier Invoices, holds the Vendor Id
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Denom Currency Code
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Acct Currency Code
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Project Currency Code
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	Project Functional Currency Code
BILLABLE_FLAG	VARCHAR2	(1)	For Expenditure Items holds Billable Flag
REQUEST_ID	NUMBER	(15)	Request Id stamped temporarily during processing on the CDL of an Expenditure Item
ADJUSTMENT_TYPE	VARCHAR2	(150)	Adjustment Type Code
JOB_ID	NUMBER	(15)	Identifier of the job of employee
NON_LABOR_RESOURCE	VARCHAR2	(20)	Non Labor Resource
NON_LABOR_RESOURCE_ORGN_ID	NUMBER	(15)	Identifier of the organization that owns the non labor resource
WIP_RESOURCE_ID	NUMBER		Identifier of the resource for work in progress
INCURRED_BY_PERSON_ID	NUMBER	(15)	Identifier of the employee who incurred the charges
INVENTORY_ITEM_ID	NUMBER		Identifier of the inventory item
ORG_ID	NUMBER	(15)	Identifier of the Expenditure Operating Unit
ACCT_RATE_DATE	DATE		Functional currency exchange rate date.
ACCT_RATE_TYPE	VARCHAR2	(30)	Functional currency exchange rate type.
ACCT_EXCHANGE_RATE	NUMBER		Functional currency exchange rate.
PROJECT_RATE_DATE	DATE		Project currency exchange rate date.
PROJECT_RATE_TYPE	VARCHAR2	(30)	Project currency exchange rate type.
PROJECT_EXCHANGE_RATE	NUMBER		Project currency exchange rate.
PROJFUNC_COST_RATE_DATE	DATE		Project Functional currency exchange rate date.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)	Project Functional currency exchange rate type.
PROJFUNC_COST_EXCHANGE_RATE	NUMBER		Project Functional currency exchange rate.
CBS_ELEMENT_ID	NUMBER	(15)	The unique identifier of the cost breakdown structure element.

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      PA_DATE
,      PA_PERIOD_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE_CATEGORY
,      PERSON_TYPE
,      PO_LINE_ID
,      SYSTEM_LINKAGE_FUNCTION
,      IND_COST_CODE
,      EI_EXPENDITURE_TYPE
,      ICC_EXPENDITURE_TYPE
,      COST_BASE
,      COMPILED_MULTIPLIER
,      IND_COMPILED_SET_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      EXPENDITURE_ITEM_DATE
,      BURDEN_COST
,      DENOM_BURDENED_COST
,      ACCT_BURDENED_COST
,      PROJECT_BURDENED_COST
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      SYSTEM_REFERENCE1
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
,      BILLABLE_FLAG
,      REQUEST_ID
,      ADJUSTMENT_TYPE
,      JOB_ID
,      NON_LABOR_RESOURCE
,      NON_LABOR_RESOURCE_ORGN_ID
,      WIP_RESOURCE_ID
,      INCURRED_BY_PERSON_ID
,      INVENTORY_ITEM_ID
,      ORG_ID
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      CBS_ELEMENT_ID
FROM APPS.PA_CDL_BURDEN_DETAIL_V;

Dependencies

[top of page]

APPS.PA_CDL_BURDEN_DETAIL_V references the following:

APPS: GMS_AWARD_DISTRIBUTIONS; PA_BURDEN_COSTING - show dependent code; PA_COMPILED_MULTIPLIERS; PA_CURRENCY - show dependent code; PA_EI_CDL_CM_GTEMP; PA_IND_COST_CODES

APPS.PA_CDL_BURDEN_DETAIL_V is referenced by following:

APPS: PA_CDL_BURDEN_SUMMARY_V