VIEW: APPS.PSBBV_ACCOUNT_SET_LISTS

Source

View Text - Preformatted

SELECT 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_code_combinations gcc, psb_account_position_sets st WHERE bp.account_position_set_id = st.account_position_set_id AND bp.code_combination_id = gcc.code_combination_id with read only

View Text - HTML Formatted

SELECT 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_CODE_COMBINATIONS GCC
, PSB_ACCOUNT_POSITION_SETS ST
WHERE BP.ACCOUNT_POSITION_SET_ID = ST.ACCOUNT_POSITION_SET_ID
AND BP.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY