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_ACCOUNT_LINES

Object Details

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

View Type

A Business Intelligence System view

PSBFV_WS_ACCOUNT_LINES displays information about worksheet account lines.

[View Source]

Columns

Name	Datatype	Length	Comments
BUDGET_YEAR_NAME	VARCHAR2	(15)	Budget year name
SERVICE_PACKAGE_NAME	VARCHAR2	(15)	Short name of service package for worksheet account line
PAY_ELEMENT_NAME	VARCHAR2	(30)	Pay element name
_LA:BALANCE_TYPE	CHAR	(57)	Balance type. B indicates Budget, A indicates Actual, or E indicates Estimate.
TEMPLATE_NAME	VARCHAR2	(100)	Summary template name
_LA:ACCOUNT_TYPE	CHAR	(53)	General Ledger account type. A indicates Asset, L indicates Liability, O indicates Equity, R indicates Revenue, or E indicates Expense.
NOTE	VARCHAR2	(4000)	Description associated with account line
ANNUAL_FTE	NUMBER		Full-time equivalency factor computed by annualizing period full-time equivalencies
CURRENCY_CODE	VARCHAR2	(10)	Functional currency of General Ledger Set of Books or STAT for statistical currency. Indicates the currency of the YTD_AMOUNT.
YEAR_AMOUNT	NUMBER		Year-to-date amount
PERIOD1_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD2_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD3_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD4_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD5_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD6_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD7_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD8_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD9_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD10_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD11_AMOUNT	NUMBER		Amount allocated to periods in budget year
PERIOD12_AMOUNT	NUMBER		Amount allocated to periods in budget year
SET_OF_BOOKS_NAME	VARCHAR2	(30)	General Ledger Set of Books name
_KF:GL_ACCOUNT	CHAR	(17)	General Ledger account
START_STAGE_SEQ	NUMBER		Stage in which annual amount established
CURRENT_STAGE_SEQ	NUMBER		Current stage of account line
END_STAGE_SEQ	NUMBER		Stage up to which annual amount remains unchanged
WORKSHEET_ID	NUMBER	(20)	Worksheet identifier
SET_OF_BOOKS_ID	NUMBER	(15)	General Ledger Set of Books identifier
ACCOUNT_LINE_ID	NUMBER	(20)	Account line unique identifier
POSITION_LINE_ID	NUMBER		Position line unique identifier
CODE_COMBINATION_ID	NUMBER	(20)	General Ledger code combination unique identifier
SERVICE_PACKAGE_ID	NUMBER	(20)	Service package unique identifier. Service package to which line is assigned.
BUDGET_YEAR_ID	NUMBER	(20)	Budget year unique identifier. Budget year for which account line is assigned.
TEMPLATE_ID	NUMBER		General Ledger summary template unique identifier. Column has a value for summary account lines.
PAY_ELEMENT_ID	NUMBER		Pay element unique identifier. Element for which account line is created.
ELEMENT_SET_ID	NUMBER	(20)	Element set identifier. Used to group a set of account lines for a given position for a given element. Distribution percentages can be modified within a group.
NOTE_ID	NUMBER		Note unique identifier. Note associated with account line.
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column

Query Text

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


SELECT BUDGET_YEAR_NAME
,      SERVICE_PACKAGE_NAME
,      PAY_ELEMENT_NAME
,      _LA:BALANCE_TYPE
,      TEMPLATE_NAME
,      _LA:ACCOUNT_TYPE
,      NOTE
,      ANNUAL_FTE
,      CURRENCY_CODE
,      YEAR_AMOUNT
,      PERIOD1_AMOUNT
,      PERIOD2_AMOUNT
,      PERIOD3_AMOUNT
,      PERIOD4_AMOUNT
,      PERIOD5_AMOUNT
,      PERIOD6_AMOUNT
,      PERIOD7_AMOUNT
,      PERIOD8_AMOUNT
,      PERIOD9_AMOUNT
,      PERIOD10_AMOUNT
,      PERIOD11_AMOUNT
,      PERIOD12_AMOUNT
,      SET_OF_BOOKS_NAME
,      _KF:GL_ACCOUNT
,      START_STAGE_SEQ
,      CURRENT_STAGE_SEQ
,      END_STAGE_SEQ
,      WORKSHEET_ID
,      SET_OF_BOOKS_ID
,      ACCOUNT_LINE_ID
,      POSITION_LINE_ID
,      CODE_COMBINATION_ID
,      SERVICE_PACKAGE_ID
,      BUDGET_YEAR_ID
,      TEMPLATE_ID
,      PAY_ELEMENT_ID
,      ELEMENT_SET_ID
,      NOTE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_WS_ACCOUNT_LINES;

Dependencies

[top of page]

APPS.PSBFV_WS_ACCOUNT_LINES references the following:

APPS: GL_CODE_COMBINATIONS_KFV; GL_SETS_OF_BOOKS; PSB_BUDGET_GROUPS; PSB_BUDGET_PERIODS; PSB_PAY_ELEMENTS; PSB_SERVICE_PACKAGES; PSB_SUMMARY_TEMPLATES; PSB_WORKSHEETS; PSB_WS_ACCOUNT_LINES; PSB_WS_ACCOUNT_LINE_NOTES; PSB_WS_ELEMENT_LINES; PSB_WS_LINES

APPS.PSBFV_WS_ACCOUNT_LINES is not referenced by any database object