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_FTE_LINES

Object Details

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

View Type

A Business Intelligence System view

PSBFV_WS_FTE_LINES displays information about worksheet full-time equivalency lines.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_NAME	VARCHAR2	(240)		Position name
SERVICE_PACKAGE_NAME	VARCHAR2	(15)	Yes	Service package name
BUDGET_YEAR_NAME	VARCHAR2	(15)	Yes	Budget year name
ANNUAL_FTE	NUMBER		Yes	Computed annual full-time equivalency value
PERIOD1_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD2_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD3_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD4_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD5_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD6_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD7_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD8_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD9_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD10_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD11_FTE	NUMBER			Full-time equivalency for periods in budget year
PERIOD12_FTE	NUMBER			Full-time equivalency for periods in budget year
START_STAGE_SEQ	NUMBER		Yes	Stage in which annual amount established
CURRENT_STAGE_SEQ	NUMBER		Yes	Current stage for account line
END_STAGE_SEQ	NUMBER			Stage up to which annual amount remained unchanged
POSITION_LINE_ID	NUMBER		Yes	Position line unique identifier
SERVICE_PACKAGE_ID	NUMBER		Yes	Service package unique identifier. Service package to which line is assigned.
BUDGET_YEAR_ID	NUMBER		Yes	Budget year unique identifier. Budget year for which account line is assigned.
FTE_LINE_ID	NUMBER		Yes	Full time equivalency line unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATED_BY	NUMBER		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
,      BUDGET_YEAR_NAME
,      ANNUAL_FTE
,      PERIOD1_FTE
,      PERIOD2_FTE
,      PERIOD3_FTE
,      PERIOD4_FTE
,      PERIOD5_FTE
,      PERIOD6_FTE
,      PERIOD7_FTE
,      PERIOD8_FTE
,      PERIOD9_FTE
,      PERIOD10_FTE
,      PERIOD11_FTE
,      PERIOD12_FTE
,      START_STAGE_SEQ
,      CURRENT_STAGE_SEQ
,      END_STAGE_SEQ
,      POSITION_LINE_ID
,      SERVICE_PACKAGE_ID
,      BUDGET_YEAR_ID
,      FTE_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_WS_FTE_LINES;

Dependencies

[top of page]

APPS.PSBFV_WS_FTE_LINES references the following:

APPS: PSB_BUDGET_PERIODS; PSB_POSITIONS; PSB_SERVICE_PACKAGES; PSB_WS_FTE_LINES; PSB_WS_POSITION_LINES

APPS.PSBFV_WS_FTE_LINES is not referenced by any database object