[Home] [Help]
View: PSB_WS_ACCOUNTS_V
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT WL.WORKSHEET_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.ACCOUNT_TYPE
, WAL.CURRENCY_CODE
, WAL.BUDGET_GROUP_ID
, WAL.TEMPLATE_ID
FROM PSB_WS_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
WHERE WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID
AND WL.VIEW_LINE_FLAG = 'Y'
AND ( ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST = 0
AND WAL.END_STAGE_SEQ IS NULL) OR ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST BETWEEN WAL.START_STAGE_SEQ
AND NVL(WAL.END_STAGE_SEQ
, 9.99E125) ) )
Columns
| Name |
| WORKSHEET_ID |
| CODE_COMBINATION_ID |
| SERVICE_PACKAGE_ID |
| ACCOUNT_TYPE |
| CURRENCY_CODE |
| BUDGET_GROUP_ID |
| TEMPLATE_ID |