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_COST_BURDEN_DETAILS_V

Object Details

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

View Type

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

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
PROJECT_NAME	VARCHAR2	(30)	Project Name
PROJECT_ID	NUMBER	(15)	Project Id
TASK_NUMBER	VARCHAR2	(25)	Task Number
TASK_NAME	VARCHAR2	(20)	Task Name
TASK_ID	NUMBER	(15)	Task Id
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	Expenditure Organization
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Expenditure Organization Id
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure Type
EXPENDITURE_ITEM_DATE	DATE		Expenditure Item Date
PA_DATE	DATE		PA Date
GL_DATE	DATE		GL date
RAW_COST	NUMBER		Raw Cost
BURDENED_COST	NUMBER		Burdened Cost
BURDEN_COST	NUMBER		Burden Cost
COST_BASE	VARCHAR2	(30)	Cost Base
CB_SORT_ORDER	NUMBER	(15)	Cost Base Sort Order
BURDEN_COST_CODE	VARCHAR2	(30)	Burden Cost Code
BCC_PRECEDENCE	NUMBER	(15)	Precedence
INPUT_MULTIPLIER	NUMBER	(22)	Input Multiplier
COMPILED_MULTIPLIER	NUMBER	(22)	Compiled Multiplier
EXPENDITURE_ITEM_ID	NUMBER	(15)	Expenditure Item Id
CDL_LINE_NUM	NUMBER	(15)	Line Number
BURDEN_SCHEDULE	VARCHAR2	(30)	Burden Schedule
BURDEN_SCHEDULE_ID	NUMBER	(15)	Burden Schedule Id
BURDEN_SCHEDULE_REVISION	VARCHAR2	(30)	Burden Schedule Revision
BURDEN_SCHEDULE_REVISION_ID	NUMBER	(15)	Burden Schedule Revision Id
BURDEN_STRUCTURE	VARCHAR2	(30)	Burden Structure
COMPILED_SET_ID	NUMBER	(15)	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

Query Text

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;

Dependencies

[top of page]

APPS.PA_COST_BURDEN_DETAILS_V references the following:

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