[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_COST_BURDEN_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_COST_BURDEN_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View of individual burden cost components of the burdened cost of each expenditure item that is burdened.This view shows the individual burden cost components of the burdened cost of each expenditure item that is burdened
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project Number |
| PROJECT_NAME | VARCHAR2 | (30) | Yes | Project Name |
| PROJECT_ID | NUMBER | (15) | Yes | Project Id |
| TASK_NUMBER | VARCHAR2 | (25) | Yes | Task Number |
| TASK_NAME | VARCHAR2 | (20) | Yes | Task Name |
| TASK_ID | NUMBER | (15) | Yes | Task Id |
| EXPENDITURE_ORGANIZATION | VARCHAR2 | (240) | Yes | Expenditure Organization |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Yes | Expenditure Organization Id |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure Type |
| EXPENDITURE_ITEM_DATE | DATE | Yes | Expenditure Item Date | |
| PA_DATE | DATE | PA Date | ||
| GL_DATE | DATE | GL date | ||
| RAW_COST | NUMBER | (22) | Yes | Raw Cost |
| BURDENED_COST | NUMBER | (22) | Burdened Cost | |
| BURDEN_COST | NUMBER | Burden Cost | ||
| COST_BASE | VARCHAR2 | (30) | Yes | Cost Base |
| CB_SORT_ORDER | NUMBER | (15) | Yes | Cost Base Sort Order |
| BURDEN_COST_CODE | VARCHAR2 | (30) | Yes | Burden Cost Code |
| BCC_PRECEDENCE | NUMBER | (15) | Yes | Precedence |
| INPUT_MULTIPLIER | NUMBER | (22) | Yes | Input Multiplier |
| COMPILED_MULTIPLIER | NUMBER | (22) | Yes | Compiled Multiplier |
| EXPENDITURE_ITEM_ID | NUMBER | (15) | Yes | Expenditure Item Id |
| CDL_LINE_NUM | NUMBER | (15) | Yes | Line Number |
| BURDEN_SCHEDULE | VARCHAR2 | (30) | Yes | Burden Schedule |
| BURDEN_SCHEDULE_ID | NUMBER | (15) | Yes | Burden Schedule Id |
| BURDEN_SCHEDULE_REVISION | VARCHAR2 | (30) | Yes | Burden Schedule Revision |
| BURDEN_SCHEDULE_REVISION_ID | NUMBER | (15) | Yes | Burden Schedule Revision Id |
| BURDEN_STRUCTURE | VARCHAR2 | (30) | Yes | Burden Structure |
| COMPILED_SET_ID | NUMBER | (15) | Yes | Compiled Set Id |
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Denomination currency code of the transaction | |
| DENOM_RAW_COST | NUMBER | Raw cost in denomination currency | ||
| DENOM_BURDEN_COST | NUMBER | Burden cost in Denomination currency | ||
| DENOM_BURDENED_COST | NUMBER | Burdened cost in Denomination currency | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Account currency code of the transaction | |
| ACCT_RAW_COST | NUMBER | Raw cost in accounting currency | ||
| ACCT_BURDEN_COST | NUMBER | Burden cost in Accounting currency | ||
| ACCT_BURDENED_COST | NUMBER | Burdened cost in Accounting currency |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, TASK_NUMBER
, TASK_NAME
, TASK_ID
, EXPENDITURE_ORGANIZATION
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, PA_DATE
, GL_DATE
, RAW_COST
, BURDENED_COST
, BURDEN_COST
, COST_BASE
, CB_SORT_ORDER
, BURDEN_COST_CODE
, BCC_PRECEDENCE
, INPUT_MULTIPLIER
, COMPILED_MULTIPLIER
, EXPENDITURE_ITEM_ID
, CDL_LINE_NUM
, BURDEN_SCHEDULE
, BURDEN_SCHEDULE_ID
, BURDEN_SCHEDULE_REVISION
, BURDEN_SCHEDULE_REVISION_ID
, BURDEN_STRUCTURE
, COMPILED_SET_ID
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDEN_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RAW_COST
, ACCT_BURDEN_COST
, ACCT_BURDENED_COST
FROM APPS.PA_COST_BURDEN_DETAILS_V;
APPS
HR_GENERAL
- show dependent code
HR_SECURITY
- show dependent code
PA_BURDEN_DETAILS_BASE_V
PA_COST_DISTRIBUTION_LINES
PA_CURRENCY
- show dependent code
PA_EXPENDITURES
PA_EXPENDITURE_ITEMS
PA_PROJECTS_ALL
PA_TASKS
APPS.PA_COST_BURDEN_DETAILS_V is not referenced by any database object
|
|
|
|