View: CE_FORECAST_ORGS_V

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

View Text

SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_AP_ORGS_V UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_PO_ORGS_V UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_PAY_ORGS_V UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_AR_ORGS_V UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_AS_ORGS_V UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_OE_ORGS_V UNION ALL SELECT NULL
, TO_NUMBER(LOOKUP_CODE)
, MEANING
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
FROM CE_LOOKUPS
WHERE LOOKUP_TYPE = 'FORECAST_ALL' UNION ALL SELECT APP_SHORT_NAME
, ORG_ID
, NAME
, SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, CURRENCY_CODE
, DESCRIPTION
FROM CE_FORECAST_PA_ORGS_V

Columns