VIEW: APPS.CE_FORECAST_ORGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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