View: CE_FORECAST_AP_ORGS_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_FORECAST_AP_ORGS_V

View Text

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

Columns