VIEW: APPS.PSBFV_ACCOUNT_SET_LISTS

Source

View Text - Preformatted

SELECT sob.name ,st.name ,'_KF:SQLGL:GL#:GCC' ,bp.account_position_set_id ,bp.code_combination_id ,bp.set_of_books_id ,bp.LAST_UPDATE_DATE ,bp.LAST_UPDATED_BY ,bp.CREATED_BY ,bp.CREATION_DATE FROM psb_budget_accounts bp, gl_sets_of_books sob, gl_code_combinations gcc, psb_account_position_sets st WHERE bp.account_position_set_id = st.account_position_set_id AND bp.set_of_books_id = sob.set_of_books_id AND bp.code_combination_id = gcc.code_combination_id with read only

View Text - HTML Formatted

SELECT SOB.NAME
, ST.NAME
, '_KF:SQLGL:GL#:GCC'
, BP.ACCOUNT_POSITION_SET_ID
, BP.CODE_COMBINATION_ID
, BP.SET_OF_BOOKS_ID
, BP.LAST_UPDATE_DATE
, BP.LAST_UPDATED_BY
, BP.CREATED_BY
, BP.CREATION_DATE
FROM PSB_BUDGET_ACCOUNTS BP
, GL_SETS_OF_BOOKS SOB
, GL_CODE_COMBINATIONS GCC
, PSB_ACCOUNT_POSITION_SETS ST
WHERE BP.ACCOUNT_POSITION_SET_ID = ST.ACCOUNT_POSITION_SET_ID
AND BP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND BP.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY