VIEW: APPS.AR_SYSTEM_PARAMETERS_OU_V

Source

View Text - Preformatted

SELECT hr.name operating_unit, hr.organization_id org_id, decode(ar.set_of_books_id,'-1','No',NULL,'No','Yes') system_option_defined from hr_operating_units hr, ar_system_parameters_all ar WHERE mo_global.check_access(hr.organization_id) = 'Y' AND hr.organization_id = ar.org_id(+) order by 2

View Text - HTML Formatted

SELECT HR.NAME OPERATING_UNIT
, HR.ORGANIZATION_ID ORG_ID
, DECODE(AR.SET_OF_BOOKS_ID
, '-1'
, 'NO'
, NULL
, 'NO'
, 'YES') SYSTEM_OPTION_DEFINED
FROM HR_OPERATING_UNITS HR
, AR_SYSTEM_PARAMETERS_ALL AR
WHERE MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID) = 'Y'
AND HR.ORGANIZATION_ID = AR.ORG_ID(+) ORDER BY 2