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.PSBFV_WS_ELEMENT_COST_LINES

Object Details

Object Name:	PSBFV_WS_ELEMENT_COST_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSBFV_WS_ELEMENT_COST_LINES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PSBFV_WS_ELEMENT_COST_LINES displays information about worksheet element cost lines.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_NAME	VARCHAR2	(240)		Position name
SERVICE_PACKAGE_NAME	VARCHAR2	(15)	Yes	Service package short name
PAY_ELEMENT_NAME	VARCHAR2	(30)	Yes	Pay element name
BUDGET_YEAR_NAME	VARCHAR2	(15)	Yes	Budget year name
ELEMENT_COST	NUMBER		Yes	Pay amount proposed for position for this element. For example, proposed salary amount for the position.
START_STAGE_SEQ	NUMBER		Yes	Stage in which annual amount established
CURRENT_STAGE_SEQ	NUMBER		Yes	Current stage of account line
END_STAGE_SEQ	NUMBER			Stage up to which annual amount remained unchanged
POSITION_LINE_ID	NUMBER	(20)	Yes	Position line unique identifier
SERVICE_PACKAGE_ID	NUMBER		Yes	Service package unique identifier. Service package to which line is assigned.
PAY_ELEMENT_ID	NUMBER	(20)	Yes	Pay element unique identifier
BUDGET_YEAR_ID	NUMBER	(15)	Yes	Budget year unique identifier. Budget year for which account line is assigned.
ELEMENT_LINE_ID	NUMBER	(20)	Yes	Element cost line unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT POSITION_NAME
,      SERVICE_PACKAGE_NAME
,      PAY_ELEMENT_NAME
,      BUDGET_YEAR_NAME
,      ELEMENT_COST
,      START_STAGE_SEQ
,      CURRENT_STAGE_SEQ
,      END_STAGE_SEQ
,      POSITION_LINE_ID
,      SERVICE_PACKAGE_ID
,      PAY_ELEMENT_ID
,      BUDGET_YEAR_ID
,      ELEMENT_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_WS_ELEMENT_COST_LINES;

Dependencies

[top of page]

APPS.PSBFV_WS_ELEMENT_COST_LINES references the following:

APPS: PSB_BUDGET_PERIODS; PSB_PAY_ELEMENTS; PSB_POSITIONS; PSB_SERVICE_PACKAGES; PSB_WS_ELEMENT_LINES; PSB_WS_POSITION_LINES

APPS.PSBFV_WS_ELEMENT_COST_LINES is not referenced by any database object