View: AR_SYSTEM_PARAMETERS_OU_V

Product:	AR - Receivables
Description:	Release 11.5
Implementation/DBA Data:	APPS.AR_SYSTEM_PARAMETERS_OU_V

View Text

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

Columns