[Home] [Help]
View: PSB_WS_ACCOUNTS_V
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 |