VIEW: APPS.PSBBV_WS_ACCOUNT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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