[Home] [Help] [Dependency Information]
Object Name: | PSBBV_WS_FTE_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_WS_FTE_LINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBBV_WS_FTE_LINES displays information about worksheet full-time equivalency lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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. | |
ANNUAL_FTE | NUMBER | Yes | Computed annual full-time equivalency value | |
PERIOD1_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD2_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD3_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD4_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD5_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD6_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD7_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD8_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD9_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD10_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD11_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
PERIOD12_FTE | NUMBER | Full-time equivalency for periods in a budget year | ||
START_STAGE_SEQ | NUMBER | Yes | Stage in which annual amount is established | |
CURRENT_STAGE_SEQ | NUMBER | Yes | Current stage of account line | |
END_STAGE_SEQ | NUMBER | Stage up to which annual amount remains unchanged | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_LINE_ID
, SERVICE_PACKAGE_ID
, BUDGET_YEAR_ID
, 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
, FTE_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.PSBBV_WS_FTE_LINES;
APPS.PSBBV_WS_FTE_LINES is not referenced by any database object
|
|
|