eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_AI_ORG_V

Product:	AR - Receivables
Description:	Selects orgs from ar_system_parameters
Implementation/DBA Data:	APPS.AR_AI_ORG_V

View Text

SELECT MEANING ORGANIZATION
, -99 ORG_ID
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'ALL' UNION SELECT HR.NAME ORGANIZATION
, AR.ORG_ID ORG_ID
FROM HR_OPERATING_UNITS HR
, AR_SYSTEM_PARAMETERS AR
WHERE AR.ORG_ID = HR.ORGANIZATION_ID ORDER BY ORGANIZATION

Columns

Name
ORGANIZATION
ORG_ID