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_DETAIL_V

Object Details

Object Name:	PA_CMT_BURDEN_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CMT_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 the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rate schedules and revisions. The project value is set in pa_burden_costing package.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Project id of the commitment transaction item whose burden components are being summarized
TASK_ID	NUMBER	(15)	Yes	task id of the commitment transaction item whose burden components are being summarized
ORGANIZATION_ID	NUMBER			Organization or the of a commitment transaction item
PA_PERIOD	VARCHAR2	(20)	Yes	Account period end date of a commitment transaction item
GL_PERIOD	VARCHAR2	(15)	Yes	GL Account period end date of a commitment transaction item
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes	Transaction source of a commitment transaction item
LINE_TYPE	VARCHAR2	(1)	Yes	Line type of a commitment transaction item
IND_COST_CODE	VARCHAR2	(30)	Yes	Indirect cost code associated with the expenditure type of commitment transaction
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(15)		Original Transaction Reference1
ORIGINAL_TXN_REFERENCE2	VARCHAR2	(15)		Original Transaction Reference2
ORIGINAL_TXN_REFERENCE3	VARCHAR2	(15)		Original Transaction Reference3
CMT_EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type of a commitment transaction
ICC_EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure type of the indirect cost code associated with a commitment transaction item.\ Each indirect cost code may be associated with one expenditure type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	Expenditure category of the expenditure type corresponding to the indirect cost code \ associated with a commitment transaction item.
REVENUE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Revenue category of the expenditure type corresponding to the indirect cost code \ associated with a commitment transaction item.
COST_BASE	VARCHAR2	(30)	Yes	Cost base code of the commitment transaction item
COMPILED_MULTIPLIER	NUMBER	(22)	Yes	Indicative code for applying the indirect cost multiplication factors for a commitment transaction item for each burden cost code
IND_RATE_SCH_ID	NUMBER	(15)	Yes	Identifier of the indirect rate schedule applied to a commitment transaction item
IND_RATE_SCH_REVISION_ID	NUMBER	(15)	Yes	RevisionIdentifier of the indirect rate schedule applied to a commitment transaction item
BURDEN_COST	NUMBER			Burden cost of a commitment transaction item for a burden cost component
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
ACCT_RAW_COST	NUMBER			The functional currency raw cost amount of the project-related commitment distribution.
ACCT_BURDENED_COST	NUMBER			The functional currency burdened cost amount of the project-related commitment distribution
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code.
DENOM_RAW_COST	NUMBER			The transaction currency raw cost amount of the project-related commitment distribution.
DENOM_BURDENED_COST	NUMBER			The transaction currency burdened cost amount of the project-related commitment distribution
ACCT_CURRENCY_CODE	VARCHAR2	(15)		The functional currency code.
ACCT_RATE_DATE	DATE			The functional currency rate date.
ACCT_RATE_TYPE	VARCHAR2	(30)		The functional currency rate type (such as Spot or Corporate).
ACCT_EXCHANGE_RATE	NUMBER			The functional currency exchange rate.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code.
PROJECT_RATE_DATE	DATE			The project currency rate date.
PROJECT_RATE_TYPE	VARCHAR2	(30)		The project currency rate type (such as Spot or Corporate).
PROJECT_EXCHANGE_RATE	NUMBER			The project currency exchange rate.
RESOURCE_CLASS	VARCHAR2	(30)		Resource Class of the transaction
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)	Yes	System Linkage Function of the Transaction
VENDOR_ID	NUMBER			Identifier of the vendor for supplier invoices
INVENTORY_ITEM_ID	NUMBER	(15)		Identifier of the inventory item
BOM_LABOR_RESOURCE_ID	NUMBER	(15)		Identifier for BOM labor resource
BOM_EQUIPMENT_RESOURCE_ID	NUMBER	(15)		Identifier for BOM equipment resource

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      PA_PERIOD
,      GL_PERIOD
,      TRANSACTION_SOURCE
,      LINE_TYPE
,      IND_COST_CODE
,      ORIGINAL_TXN_REFERENCE1
,      ORIGINAL_TXN_REFERENCE2
,      ORIGINAL_TXN_REFERENCE3
,      CMT_EXPENDITURE_TYPE
,      ICC_EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      COST_BASE
,      COMPILED_MULTIPLIER
,      IND_RATE_SCH_ID
,      IND_RATE_SCH_REVISION_ID
,      BURDEN_COST
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      RESOURCE_CLASS
,      SYSTEM_LINKAGE_FUNCTION
,      VENDOR_ID
,      INVENTORY_ITEM_ID
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIPMENT_RESOURCE_ID
FROM APPS.PA_CMT_BURDEN_DETAIL_V;

Dependencies

[top of page]

APPS.PA_CMT_BURDEN_DETAIL_V references the following:

APPS: PA_BURDEN_COSTING - show dependent code; PA_COMMITMENT_TXNS; PA_COMPILED_MULTIPLIERS; PA_COST_BASES; PA_COST_BASE_EXP_TYPES; PA_EXPENDITURE_TYPES; PA_IND_COMPILED_SETS; PA_IND_COST_CODES; PA_IND_RATE_SCHEDULES_ALL_BG; PA_IND_RATE_SCH_REVISIONS; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL

APPS.PA_CMT_BURDEN_DETAIL_V is referenced by following:

APPS: PA_CMT_BURDEN_SUMMARY_V