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.

[Home] [Help]

View: PSBBV_WS_ACCOUNT_LINES

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBBV_WS_ACCOUNT_LINES

View Text

SELECT WL.WORKSHEET_ID
, WL.ACCOUNT_LINE_ID
, WAL.POSITION_LINE_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.ELEMENT_SET_ID
, WAL.BUDGET_YEAR_ID
, '_LA:WAL.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, WAL.TEMPLATE_ID
, '_LA:WAL.ACCOUNT_TYPE:FND_LOOKUPS:ACCOUNT_TYPE:MEANING'
, WAL.ANNUAL_FTE
, WAL.NOTE_ID
, WAL.CURRENCY_CODE
, WAL.YTD_AMOUNT
, WAL.PERIOD1_AMOUNT
, WAL.PERIOD2_AMOUNT
, WAL.PERIOD3_AMOUNT
, WAL.PERIOD4_AMOUNT
, WAL.PERIOD5_AMOUNT
, WAL.PERIOD6_AMOUNT
, WAL.PERIOD7_AMOUNT
, WAL.PERIOD8_AMOUNT
, WAL.PERIOD9_AMOUNT
, WAL.PERIOD10_AMOUNT
, WAL.PERIOD11_AMOUNT
, WAL.PERIOD12_AMOUNT
, WAL.START_STAGE_SEQ
, WAL.CURRENT_STAGE_SEQ
, WAL.END_STAGE_SEQ
, WAL.LAST_UPDATE_DATE
, WAL.LAST_UPDATED_BY
, WAL.CREATED_BY
, WAL.CREATION_DATE
FROM PSB_WS_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
WHERE WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID WITH READ ONLY

Columns

Name
WORKSHEET_ID
ACCOUNT_LINE_ID
POSITION_LINE_ID
CODE_COMBINATION_ID
SERVICE_PACKAGE_ID
ELEMENT_SET_ID
BUDGET_YEAR_ID
"_LA:BALANCE_TYPE"
TEMPLATE_ID
"_LA:ACCOUNT_TYPE"
ANNUAL_FTE
NOTE_ID
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
START_STAGE_SEQ
CURRENT_STAGE_SEQ
END_STAGE_SEQ
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE