VIEW: APPS.PSA_EFC_OPTIONS_V

Source

View Text - Preformatted

SELECT GSOB.SET_OF_BOOKS_ID ,GSOB.NAME ,EOPT.MULT_FUNDING_BUDGETS_FLAG FROM GL_SETS_OF_BOOKS GSOB, PSA_EFC_OPTIONS EOPT WHERE gsob.set_of_books_id = eopt.set_of_books_id(+) AND gsob.mrc_sob_type_code != 'R' AND gsob.enable_budgetary_control_flag = 'Y'

View Text - HTML Formatted

SELECT GSOB.SET_OF_BOOKS_ID
, GSOB.NAME
, EOPT.MULT_FUNDING_BUDGETS_FLAG
FROM GL_SETS_OF_BOOKS GSOB
, PSA_EFC_OPTIONS EOPT
WHERE GSOB.SET_OF_BOOKS_ID = EOPT.SET_OF_BOOKS_ID(+)
AND GSOB.MRC_SOB_TYPE_CODE != 'R'
AND GSOB.ENABLE_BUDGETARY_CONTROL_FLAG = 'Y'