View: PSBFV_WS_ACCOUNT_LINES

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

View Text

SELECT BP.NAME
, SP.SHORT_NAME
, PAY.NAME ELEMENT_NAME
, '_LA:WAL.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, ST.TEMPLATE_NAME
, '_LA:WAL.ACCOUNT_TYPE:FND_LOOKUPS:ACCOUNT_TYPE:MEANING'
, WALN.NOTE
, WAL.ANNUAL_FTE
, 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
, SOB.NAME
, '_KF:SQLGL:GL#:GCC'
, WAL.START_STAGE_SEQ
, WAL.CURRENT_STAGE_SEQ
, WAL.END_STAGE_SEQ
, WS.WORKSHEET_ID
, SOB.SET_OF_BOOKS_ID
, WL.ACCOUNT_LINE_ID
, WAL.POSITION_LINE_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.BUDGET_YEAR_ID
, WAL.TEMPLATE_ID
, WEL.PAY_ELEMENT_ID
, WAL.ELEMENT_SET_ID
, WAL.NOTE_ID
, WAL.LAST_UPDATE_DATE
, WAL.LAST_UPDATED_BY
, WAL.CREATED_BY
, WAL.CREATION_DATE
FROM PSB_WS_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
, PSB_WORKSHEETS WS
, PSB_BUDGET_GROUPS BG
, PSB_BUDGET_GROUPS BG1
, GL_SETS_OF_BOOKS SOB
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
, PSB_SUMMARY_TEMPLATES ST
, GL_CODE_COMBINATIONS_KFV GCC
, PSB_WS_ELEMENT_LINES WEL
, PSB_PAY_ELEMENTS PAY
, PSB_WS_ACCOUNT_LINE_NOTES WALN
WHERE WL.WORKSHEET_ID = WS.WORKSHEET_ID
AND BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID
AND BG1.BUDGET_GROUP_ID = NVL(BG.ROOT_BUDGET_GROUP_ID
, BG.BUDGET_GROUP_ID)
AND SOB.SET_OF_BOOKS_ID = BG1.SET_OF_BOOKS_ID
AND WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID
AND WAL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND WAL.BUDGET_YEAR_ID = BP.BUDGET_PERIOD_ID
AND WAL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WAL.NOTE_ID = WALN.NOTE_ID(+)
AND WAL.TEMPLATE_ID = ST.TEMPLATE_ID(+)
AND WAL.POSITION_LINE_ID IS NOT NULL
AND WAL.POSITION_LINE_ID = WEL.POSITION_LINE_ID
AND WAL.ELEMENT_SET_ID = WEL.ELEMENT_SET_ID
AND WAL.BUDGET_YEAR_ID = WEL.BUDGET_YEAR_ID
AND PAY.PAY_ELEMENT_ID = WEL.PAY_ELEMENT_ID
AND WAL.CURRENT_STAGE_SEQ=WEL.CURRENT_STAGE_SEQ UNION ALL SELECT BP.NAME
, SP.SHORT_NAME
, NULL ELEMENT_NAME
, '_LA:WAL.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, ST.TEMPLATE_NAME
, '_LA:WAL.ACCOUNT_TYPE:FND_LOOKUPS:ACCOUNT_TYPE:MEANING'
, WALN.NOTE
, WAL.ANNUAL_FTE
, 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
, SOB.NAME
, '_KF:SQLGL:GL#:GCC'
, WAL.START_STAGE_SEQ
, WAL.CURRENT_STAGE_SEQ
, WAL.END_STAGE_SEQ
, WS.WORKSHEET_ID
, SOB.SET_OF_BOOKS_ID
, WL.ACCOUNT_LINE_ID
, WAL.POSITION_LINE_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.BUDGET_YEAR_ID
, WAL.TEMPLATE_ID
, TO_NUMBER(NULL) PAY_ELEMENT_ID
, WAL.ELEMENT_SET_ID
, WAL.NOTE_ID
, WAL.LAST_UPDATE_DATE
, WAL.LAST_UPDATED_BY
, WAL.CREATED_BY
, WAL.CREATION_DATE
FROM PSB_WS_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
, PSB_WORKSHEETS WS
, PSB_BUDGET_GROUPS BG
, PSB_BUDGET_GROUPS BG1
, GL_SETS_OF_BOOKS SOB
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
, PSB_SUMMARY_TEMPLATES ST
, GL_CODE_COMBINATIONS_KFV GCC
, PSB_WS_ACCOUNT_LINE_NOTES WALN
WHERE WL.WORKSHEET_ID = WS.WORKSHEET_ID
AND BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID
AND BG1.BUDGET_GROUP_ID = NVL(BG.ROOT_BUDGET_GROUP_ID
, BG.BUDGET_GROUP_ID)
AND SOB.SET_OF_BOOKS_ID = BG1.SET_OF_BOOKS_ID
AND WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID
AND WAL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND WAL.BUDGET_YEAR_ID = BP.BUDGET_PERIOD_ID
AND WAL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WAL.NOTE_ID = WALN.NOTE_ID(+)
AND WAL.TEMPLATE_ID = ST.TEMPLATE_ID(+)
AND WAL.POSITION_LINE_ID IS NULL WITH READ ONLY

Columns