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

VIEW: APPS.PA_CDL_BURDEN_SUMMARY_V

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

View Type

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


This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary group.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_PROJECT_ID NUMBER (15)
Project id to which a CDL which is being summarized belongs to. The column alias must be SOURCE_PROJECT_ID
SOURCE_TASK_ID NUMBER (15)
Task id to which a CDL which is being summarized belongs to. The column alias must be SOURCE_TASK_ID
SOURCE_ORG_ID NUMBER

Expenditure organization or the incurred Organization. The column alias must be source_ORG_ID
SOURCE_PA_DATE DATE

Accounting closing date of expenditure item. The column alias must be source_PA_DATE
SOURCE_PA_PERIOD_NAME VARCHAR2 (4000)
PA Period name of the source transaction
SOURCE_ATTRIBUTE1 VARCHAR2 (150)
Flexfield 1 of expenditure item. This can be used for user defined grouping. this field is used as award_id in Grants Accounting.\ The alias must be source_ATTRIBUTE1
SOURCE_ATTRIBUTE2 VARCHAR2 (150)
Flexfield 2 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE2
SOURCE_ATTRIBUTE3 VARCHAR2 (150)
Flexfield 3 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE3
SOURCE_ATTRIBUTE4 VARCHAR2 (150)
Flexfield 4 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE4
SOURCE_ATTRIBUTE5 VARCHAR2 (150)
Flexfield 5 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE5
SOURCE_ATTRIBUTE6 VARCHAR2 (150)
Flexfield 6 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE6
SOURCE_ATTRIBUTE7 VARCHAR2 (150)
Flexfield 7 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE7
SOURCE_ATTRIBUTE8 VARCHAR2 (150)
Flexfield 8 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE8
SOURCE_ATTRIBUTE9 VARCHAR2 (150)
Flexfield 9 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE9
SOURCE_ATTRIBUTE10 VARCHAR2 (150)
Flexfield 10 of expenditure item. This can be used for user defined grouping. The alias must be source_ATTRIBUTE10
SOURCE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield context field of expenditure item. The alias must be source_ATTRIBUTE_CATEGORY
SOURCE_PERSON_TYPE VARCHAR2 (30)
Type of person who incurred the expenditure
SOURCE_PO_LINE_ID NUMBER

Purchase order line identifier for imported contingent worker labor transactions
SOURCE_SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
System Linkage Function of the Expenditure Item
SOURCE_IND_COST_CODE VARCHAR2 (30)
Indirect Cost code. The column alias must be source_ind_cost_code
SOURCE_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type of the expenditure item. The column alias must be SOURCE_EXPENDITURE_TYPE
SOURCE_IND_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type corresponding to the burden cost code of the burden component of an expenditure item. \ The column alias must be SOURCE_IND_EXPENDITURE_TYPE
SOURCE_COST_BASE VARCHAR2 (30)
Indirect cost base. The column alias must be source_cost_base
SOURCE_COMPILED_MULTIPLIER NUMBER (22)
Indirect cost compiled multiplier of a CDL. The column alias must be SOURCE_compiled_multiplier
SOURCE_EXP_ITEM_ID NUMBER (15)
Expenditure item identifier. The column alias must be source_expenditure_item_id
SOURCE_LINE_NUM NUMBER (15)
Line number of a CDL under an expenditure item id. The column alias must be source_line_num
SOURCE_EXP_ITEM_DATE DATE

Date of expenditure occurance. The column alias must be source_expenditure_item_date
SOURCE_BURDEN_COST NUMBER

Burden cost(in project currency)due to a burden cost component an expenditure type of an expenditure item. \ The column alias must be source_burden_cost
SOURCE_DENOM_BURDENED_COST NUMBER

Burden cost(in denom currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_burden_cost
SOURCE_ACCT_BURDENED_COST NUMBER

Burden cost(in acct currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_burden_cost
SOURCE_PROJECT_BURDENED_COST NUMBER

Burden cost(in project currency) due to a burden cost component an expenditure type of an expenditure item . \ The column alias must be source_project_burdened_cost
SOURCE_DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination Currency Code of the Expenditure Item
SOURCE_ACCT_CURRENCY_CODE VARCHAR2 (15)
Acct Currency Code of the Expenditure Item
SOURCE_PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project Currency Code of the Expenditure Item
SOURCE_PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project Functional Currency Code of the Expenditure Item
SOURCE_ID NUMBER (15)
Burden sum_source_run_id from Cost Distribution Lines. The column alias must be source_id
SOURCE_BURDEN_REJECT_CODE VARCHAR2 (30)
Rejection reason code for a CDL not summarized due to validation errors. The column alias must be source_burden_sum_rejection_code
SOURCE_VENDOR_ID VARCHAR2 (30)
For Expense Reports - holds the Vendor Id.
DEST_ORG_ID NUMBER

Expenditure organization or the incurred Organization. The column alias must be DEST_ORG_ID, user can override this value
DEST_PA_DATE DATE

Accounting closing date of expenditure item. The column alias must be DEST_PA_DATE , user can override this value
DEST_ATTRIBUTE1 VARCHAR2 (150)
Flexfield 1 of expenditure item. This can be used for user defined grouping. this field is used as award_id in Grants Accounting.\ The alias must be DEST_ATTRIBUTE1, user can override this value
DEST_IND_EXPENDITURE_TYPE VARCHAR2 (30)
The Expenditure Type of the summary burden transaction
BILLABLE_FLAG VARCHAR2 (1)
Identifier of the billability of the transaction
SOURCE_ADJUSTMENT_TYPE VARCHAR2 (150)
Type of the last adjustment action on the transaction
DEST_SUMMARY_GROUP VARCHAR2 (4000)
User defined fields for summarization criteria. User can include \ source_project_id, source_task_id, cbs_element_id, organization_id, pa_date, ind_cost_code,currency codes, attribute 1 \ User can exclude the attribute1 from the list if required. This clumn must has the alias DEST_SUMMARY_GROUP, user can override this value
DEST_SUMMARY_GROUP_RESUM VARCHAR2 (4000)
Same as DEST_SUMMARY_GROUP
SOURCE_REQUEST_ID NUMBER (15)
Request id stamped on a CDL which is being summarized . The column alias must be SOURCE_REQUEST_ID
SOURCE_JOB_ID NUMBER (15)
Identifier of the job of employee
SOURCE_NL_RESOURCE VARCHAR2 (20)
Non Labor Resource
SOURCE_NL_RESOURCE_ORGN_ID NUMBER (15)
Identifier of the organization that owns the non labor resource
SOURCE_WIP_RESOURCE_ID NUMBER

Identifier of the resource for work in progress
SOURCE_INCURRED_BY_PERSON_ID NUMBER (15)
Identifier of the employee who incurred the charges
SOURCE_INVENTORY_ITEM_ID NUMBER

Identifier of the inventory item
SRC_ACCT_RATE_DATE DATE

Functional currency exchange rate date.
SRC_ACCT_RATE_TYPE VARCHAR2 (30)
Functional currency exchange rate type.
SRC_ACCT_EXCHANGE_RATE NUMBER

Functional currency exchange rate.
SRC_PROJECT_RATE_DATE DATE

Project currency exchange rate date.
SRC_PROJECT_RATE_TYPE VARCHAR2 (30)
Project currency exchange rate type.
SRC_PROJECT_EXCHANGE_RATE NUMBER

Project currency exchange rate.
SRC_PROJFUNC_COST_RATE_DATE DATE

Project Functional currency exchange rate date.
SRC_PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Project Functional currency exchange rate type.
SRC_PROJFUNC_COST_XCHNG_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 SOURCE_PROJECT_ID
,      SOURCE_TASK_ID
,      SOURCE_ORG_ID
,      SOURCE_PA_DATE
,      SOURCE_PA_PERIOD_NAME
,      SOURCE_ATTRIBUTE1
,      SOURCE_ATTRIBUTE2
,      SOURCE_ATTRIBUTE3
,      SOURCE_ATTRIBUTE4
,      SOURCE_ATTRIBUTE5
,      SOURCE_ATTRIBUTE6
,      SOURCE_ATTRIBUTE7
,      SOURCE_ATTRIBUTE8
,      SOURCE_ATTRIBUTE9
,      SOURCE_ATTRIBUTE10
,      SOURCE_ATTRIBUTE_CATEGORY
,      SOURCE_PERSON_TYPE
,      SOURCE_PO_LINE_ID
,      SOURCE_SYSTEM_LINKAGE_FUNCTION
,      SOURCE_IND_COST_CODE
,      SOURCE_EXPENDITURE_TYPE
,      SOURCE_IND_EXPENDITURE_TYPE
,      SOURCE_COST_BASE
,      SOURCE_COMPILED_MULTIPLIER
,      SOURCE_EXP_ITEM_ID
,      SOURCE_LINE_NUM
,      SOURCE_EXP_ITEM_DATE
,      SOURCE_BURDEN_COST
,      SOURCE_DENOM_BURDENED_COST
,      SOURCE_ACCT_BURDENED_COST
,      SOURCE_PROJECT_BURDENED_COST
,      SOURCE_DENOM_CURRENCY_CODE
,      SOURCE_ACCT_CURRENCY_CODE
,      SOURCE_PROJECT_CURRENCY_CODE
,      SOURCE_PROJFUNC_CURRENCY_CODE
,      SOURCE_ID
,      SOURCE_BURDEN_REJECT_CODE
,      SOURCE_VENDOR_ID
,      DEST_ORG_ID
,      DEST_PA_DATE
,      DEST_ATTRIBUTE1
,      DEST_IND_EXPENDITURE_TYPE
,      BILLABLE_FLAG
,      SOURCE_ADJUSTMENT_TYPE
,      DEST_SUMMARY_GROUP
,      DEST_SUMMARY_GROUP_RESUM
,      SOURCE_REQUEST_ID
,      SOURCE_JOB_ID
,      SOURCE_NL_RESOURCE
,      SOURCE_NL_RESOURCE_ORGN_ID
,      SOURCE_WIP_RESOURCE_ID
,      SOURCE_INCURRED_BY_PERSON_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SRC_ACCT_RATE_DATE
,      SRC_ACCT_RATE_TYPE
,      SRC_ACCT_EXCHANGE_RATE
,      SRC_PROJECT_RATE_DATE
,      SRC_PROJECT_RATE_TYPE
,      SRC_PROJECT_EXCHANGE_RATE
,      SRC_PROJFUNC_COST_RATE_DATE
,      SRC_PROJFUNC_COST_RATE_TYPE
,      SRC_PROJFUNC_COST_XCHNG_RATE
,      CBS_ELEMENT_ID
FROM APPS.PA_CDL_BURDEN_SUMMARY_V;

Dependencies

[top of page]

APPS.PA_CDL_BURDEN_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackagePA_BURDEN_COSTING - show dependent code
ViewPA_CDL_BURDEN_DETAIL_V
PL/SQL PackagePA_CLIENT_EXTN_BURDEN_RESOURCE - show dependent code
PL/SQL PackagePA_CLIENT_EXTN_BURDEN_SUMMARY - show dependent code
PL/SQL PackagePA_CURRENCY - show dependent code
APPS.PA_CDL_BURDEN_SUMMARY_V is referenced by following:

SchemaAPPS
Package BodyPA_BURDEN_COSTING - show dependent code