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_BURDEN_DETAILS_BASE_V

Object Details

Object Name:	PA_BURDEN_DETAILS_BASE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_BURDEN_DETAILS_BASE_V
Subobject Name:
Status:	VALID

View Type

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

This view is used to display burden cost components for a given compiled set id,expenditure type, and expenditure organization.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPILED_SET_ID	NUMBER	(15)	Yes	Compiled Set Id
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	Yes	Expenditure Organization
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	Expenditure Organization Id
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure Type
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	Burden Cost Code Precedence
INPUT_MULTIPLIER	NUMBER	(22)	Yes	Input Multiplier
COMPILED_MULTIPLIER	NUMBER	(22)	Yes	Compiled Multiplier
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

Query Text

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


SELECT COMPILED_SET_ID
,      EXPENDITURE_ORGANIZATION
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      COST_BASE
,      CB_SORT_ORDER
,      BURDEN_COST_CODE
,      BCC_PRECEDENCE
,      INPUT_MULTIPLIER
,      COMPILED_MULTIPLIER
,      BURDEN_SCHEDULE
,      BURDEN_SCHEDULE_ID
,      BURDEN_SCHEDULE_REVISION
,      BURDEN_SCHEDULE_REVISION_ID
,      BURDEN_STRUCTURE
FROM APPS.PA_BURDEN_DETAILS_BASE_V;

Dependencies

[top of page]

APPS.PA_BURDEN_DETAILS_BASE_V references the following:

APPS: HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PA_COMPILED_MULTIPLIERS; PA_COST_BASES; PA_COST_BASE_EXP_TYPES; PA_IND_COMPILED_SETS; PA_IND_RATE_SCHEDULES_ALL_BG; PA_IND_RATE_SCH_REVISIONS

APPS.PA_BURDEN_DETAILS_BASE_V is referenced by following:

APPS: PA_BURDEN_COMPONENT_CMT_V; PA_BURDEN_COMPONENT_COST_V; PA_COST_BURDEN_DETAILS_V; PA_INV_BURDEN_DETAILS_V; PA_REV_BURDEN_DETAILS_V