DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_CMT_BURDEN_SUMMARY_V

Object Details
Object Name: PA_CMT_BURDEN_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CMT_BURDEN_SUMMARY_V
Subobject Name:
Status: VALID

View Type

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


This user customizable view defines the summarization criteria for burden summarization of commitment transactions. The columns which are allowed to customize have column alias prefix - dest. All other columns with column alias prefix of - source should not be customized. By customizable means that the user can include or exclude that column from the summarization group, or the user can replace it with a constant value. For e.g. dest_org_id can be included or excluded from the summary group field or replaced by a constant value.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_PROJECT_ID NUMBER (15) Yes Project id of the commitment transaction item whose burden components are being summarized
SOURCE_TASK_ID NUMBER (15) Yes task id of the commitment transaction item whose burden components are being summarized
SOURCE_ORG_ID NUMBER

Organization actually incurred the expenses or the overriding organization of commitment transaction
SOURCE_PA_PERIOD VARCHAR2 (20) Yes Account period end date of commitment transaction
SOURCE_GL_PERIOD VARCHAR2 (15) Yes GL Account period end date of commitment transaction
SOURCE_TXN_SOURCE VARCHAR2 (30) Yes Transaction source of a commitment transaction item
SOURCE_LINE_TYPE VARCHAR2 (1) Yes Line type of a commitment transaction item
SOURCE_IND_COST_CODE VARCHAR2 (30) Yes Indirect cost code associated with the expenditure type of commitment transaction
SOURCE_TXN_REF1 VARCHAR2 (30)
Source Transaction Reference1
SOURCE_TXN_REF2 VARCHAR2 (15)
Source Transaction Reference2
SOURCE_TXN_REF3 VARCHAR2 (15)
Source Transaction Reference3
SOURCE_EXPENDITURE_TYPE VARCHAR2 (30) Yes Expenditure type of commitment transaction
SOURCE_IND_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type of the indirect cost code associated with commitment transaction. Each indirect cost code may be associated with one expenditure type
SOURCE_EXP_CATEGORY VARCHAR2 (30) Yes Expenditure category of the expenditure type corresponding to the indirect cost code \ associated with a commitment transaction item.
SOURCE_REVENUE_CATEGORY VARCHAR2 (30) Yes Revenue category of the expenditure type corresponding to the indirect cost code \ associated with a commitment transaction item.
SOURCE_COST_BASE VARCHAR2 (30) Yes Cost base code of commitment transaction
SOURCE_COMPILED_MULTIPLIER NUMBER (22) Yes Indicative code for applying the indirect cost multiplication factors for the commitment transaction for each burden cost code L
SOURCE_IND_RATE_SCH_ID NUMBER (15) Yes Identifier of the indirect rate schedule applied to a commitment transaction
SOURCE_IND_RATE_SCH_REV_ID NUMBER (15) Yes RevisionIdentifier of the indirect rate schedule applied to a commitment transaction
SOURCE_BURDEN_COST NUMBER

Burden cost of a commitment transaction item for a burden cost component
SOURCE_RUN_ID NUMBER (15)
Unique number identifying the run of a burden summarization process. All the transactions processed,summarized burden \ expenditure items created during a run are stamped with one run id fro sequence pa_burden_sum_run_id_s
SOURCE_BURDEN_SUM_REJ_CODE VARCHAR2 (30)
Code identifies the rejection reason for a CDL during summarization. Rejected transactions can be corrected for the \ error and they will be summarized in the susequent run
RESOURCE_CLASS VARCHAR2 (30)
Resource Class of the transaction
SOURCE_SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30) Yes Resource Class of the transaction
DEST_PROJECT_ID NUMBER (15) Yes project_id to which the buren costs of expenditure items are accounted to, this is set at project type level\ This field can be modified by user to include, exclude or replace with a constant
DEST_TASK_ID NUMBER (15) Yes task_id to which the buren costs of expenditure items are accounted to, this is set at project type level\ This field can be modified by user to include, exclude or replace with a constant
DEST_ORG_ID NUMBER

Organization actually incurred the expenses or the overriding organization of an expenditure item\ This field can be customized by user to include, exclude or replace with a constant
DEST_IND_EXP_TYPE VARCHAR2 (30)
Destination expenditure type of the indirect cost code associated with commitment transaction. Each indirect cost code may be associated with one expenditure type
DEST_TXN_REF1 VARCHAR2 (30)
Destination Transaction Reference1
DEST_PA_PERIOD VARCHAR2 (20) Yes Account period end date of an expenditure item \ This field can be customized by user to include, exclude or replace with a constant
DEST_GL_PERIOD VARCHAR2 (15) Yes GL Account period end date of an expenditure item \ This field can be customized by user to include, exclude or replace with a constant
DEST_TXN_SOURCE VARCHAR2 (30) Yes Transaction source code of a commitment transaction , \ This field can be customized by user to include, exclude or replace with a constant
DEST_EXP_CATEGORY VARCHAR2 (30) Yes Expenditure category of a commitment transaction
DEST_REVENUE_CATEGORY VARCHAR2 (30) Yes Revenue category of a commitment transaction.
DEST_LINE_TYPE VARCHAR2 (1) Yes Line type of commitment transaction . \ This field can be customized by user to include, exclude or replace with a constant
DEST_IND_COST_CODE VARCHAR2 (30) Yes Indirect cost code of the commitment transaction corresponding to it's compiled set id . \ This field can be customized by user to include, exclude or replace with a constant
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
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
DEST_SUMMARY_GROUP VARCHAR2 (4000)
User defined fields for summarization criteria. User can include \ source_project_id, source_task_id, source_org_id, source_gl_date, source_pa_date, source_ind_cost_code, attribute 1 \ User can exclude the attribute1 from the list if required. This clumn must has the alias DEST_SUMMARY_GROUP
Query Text

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


SELECT SOURCE_PROJECT_ID
,      SOURCE_TASK_ID
,      SOURCE_ORG_ID
,      SOURCE_PA_PERIOD
,      SOURCE_GL_PERIOD
,      SOURCE_TXN_SOURCE
,      SOURCE_LINE_TYPE
,      SOURCE_IND_COST_CODE
,      SOURCE_TXN_REF1
,      SOURCE_TXN_REF2
,      SOURCE_TXN_REF3
,      SOURCE_EXPENDITURE_TYPE
,      SOURCE_IND_EXPENDITURE_TYPE
,      SOURCE_EXP_CATEGORY
,      SOURCE_REVENUE_CATEGORY
,      SOURCE_COST_BASE
,      SOURCE_COMPILED_MULTIPLIER
,      SOURCE_IND_RATE_SCH_ID
,      SOURCE_IND_RATE_SCH_REV_ID
,      SOURCE_BURDEN_COST
,      SOURCE_RUN_ID
,      SOURCE_BURDEN_SUM_REJ_CODE
,      RESOURCE_CLASS
,      SOURCE_SYSTEM_LINKAGE_FUNCTION
,      DEST_PROJECT_ID
,      DEST_TASK_ID
,      DEST_ORG_ID
,      DEST_IND_EXP_TYPE
,      DEST_TXN_REF1
,      DEST_PA_PERIOD
,      DEST_GL_PERIOD
,      DEST_TXN_SOURCE
,      DEST_EXP_CATEGORY
,      DEST_REVENUE_CATEGORY
,      DEST_LINE_TYPE
,      DEST_IND_COST_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
,      VENDOR_ID
,      INVENTORY_ITEM_ID
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIPMENT_RESOURCE_ID
,      DEST_SUMMARY_GROUP
FROM APPS.PA_CMT_BURDEN_SUMMARY_V;

Dependencies

[top of page]

APPS.PA_CMT_BURDEN_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackagePA_BURDEN_COSTING - show dependent code
PL/SQL PackagePA_CLIENT_EXTN_BURDEN_RESOURCE - show dependent code
ViewPA_CMT_BURDEN_DETAIL_V
APPS.PA_CMT_BURDEN_SUMMARY_V is referenced by following:

SchemaAPPS
Package BodyPA_BURDEN_COSTING - show dependent code