VIEW: APPS.PSBFV_WS_ACCOUNT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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