[Home] [Help]
View: CE_FORECAST_PO_ORGS_V
View Text
SELECT 'PO'
, PO.ORG_ID
, HRO.NAME
, PO.SET_OF_BOOKS_ID
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL) /* TO_NUMBER(HRO.LEGAL_ENTITY_ID)*/
FROM FINANCIALS_SYSTEM_PARAMS_ALL PO
, HR_OPERATING_UNITS HRO
, GL_SETS_OF_BOOKS GL
WHERE PO.ORG_ID = HRO.ORGANIZATION_ID
AND PO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID UNION ALL SELECT 'PO'
, PO.ORG_ID
, NULL
, PO.SET_OF_BOOKS_ID
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL)
FROM FINANCIALS_SYSTEM_PARAMS_ALL PO
, GL_SETS_OF_BOOKS GL WHERE PO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID AND PO.ORG_ID IS NULL
Columns
Name |
APP_SHORT_NAME |
ORG_ID |
NAME |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
CURRENCY_CODE |
DESCRIPTION |
LEGAL_ENTITY_ID |