VIEW: APPS.CE_FORECAST_AR_ORGS_V

Source

View Text - Preformatted

SELECT 'AR' , AR.ORG_ID , HRO.NAME , AR.SET_OF_BOOKS_ID , GL.NAME , GL.CURRENCY_CODE , GL.DESCRIPTION , to_number(NULL) /* to_number(HRO.LEGAL_ENTITY_ID)*/ FROM AR_SYSTEM_PARAMETERS_ALL AR, HR_OPERATING_UNITS HRO, GL_SETS_OF_BOOKS GL WHERE AR.ORG_ID = HRO.ORGANIZATION_ID AND AR.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID UNION ALL SELECT 'AR' , AR.ORG_ID , NULL , AR.SET_OF_BOOKS_ID , GL.NAME , GL.CURRENCY_CODE , GL.DESCRIPTION , to_number(NULL) FROM AR_SYSTEM_PARAMETERS_ALL AR , GL_SETS_OF_BOOKS GL WHERE AR.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID AND AR.org_id IS NULL

View Text - HTML Formatted

SELECT 'AR'
, AR.ORG_ID
, HRO.NAME
, AR.SET_OF_BOOKS_ID
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL) /* TO_NUMBER(HRO.LEGAL_ENTITY_ID)*/
FROM AR_SYSTEM_PARAMETERS_ALL AR
, HR_OPERATING_UNITS HRO
, GL_SETS_OF_BOOKS GL
WHERE AR.ORG_ID = HRO.ORGANIZATION_ID
AND AR.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID UNION ALL SELECT 'AR'
, AR.ORG_ID
, NULL
, AR.SET_OF_BOOKS_ID
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL)
FROM AR_SYSTEM_PARAMETERS_ALL AR
, GL_SETS_OF_BOOKS GL
WHERE AR.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND AR.ORG_ID IS NULL