VIEW: APPS.CE_FORECAST_OE_ORGS_V

Source

View Text - Preformatted

SELECT 'OE' , TO_NUMBER(HRO.ORGANIZATION_ID) , HRO.NAME , TO_NUMBER(HRO.SET_OF_BOOKS_ID) , GL.NAME , GL.CURRENCY_CODE , GL.DESCRIPTION , to_number(NULL) /* to_number(HRO.LEGAL_ENTITY_ID)*/ FROM HR_OPERATING_UNITS HRO, GL_SETS_OF_BOOKS GL WHERE HRO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID AND HRO.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') UNION ALL SELECT 'OE', TO_NUMBER(HRO.ORGANIZATION_ID) , HRO.NAME , TO_NUMBER(OE.PROFILE_OPTION_VALUE), GL.NAME, GL.CURRENCY_CODE, GL.DESCRIPTION, to_number(NULL) FROM FND_PROFILE_OPTION_VALUES OE, GL_SETS_OF_BOOKS GL, HR_OPERATING_UNITS HRO WHERE OE.PROFILE_OPTION_VALUE = GL.SET_OF_BOOKS_ID AND HRO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID AND OE.APPLICATION_ID = 300 AND OE.PROFILE_OPTION_ID = 1148 AND FND_PROFILE.VALUE('ORG_ID') IS NULL

View Text - HTML Formatted

SELECT 'OE'
, TO_NUMBER(HRO.ORGANIZATION_ID)
, HRO.NAME
, TO_NUMBER(HRO.SET_OF_BOOKS_ID)
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL) /* TO_NUMBER(HRO.LEGAL_ENTITY_ID)*/
FROM HR_OPERATING_UNITS HRO
, GL_SETS_OF_BOOKS GL
WHERE HRO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND HRO.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') UNION ALL SELECT 'OE'
, TO_NUMBER(HRO.ORGANIZATION_ID)
, HRO.NAME
, TO_NUMBER(OE.PROFILE_OPTION_VALUE)
, GL.NAME
, GL.CURRENCY_CODE
, GL.DESCRIPTION
, TO_NUMBER(NULL)
FROM FND_PROFILE_OPTION_VALUES OE
, GL_SETS_OF_BOOKS GL
, HR_OPERATING_UNITS HRO
WHERE OE.PROFILE_OPTION_VALUE = GL.SET_OF_BOOKS_ID
AND HRO.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND OE.APPLICATION_ID = 300
AND OE.PROFILE_OPTION_ID = 1148
AND FND_PROFILE.VALUE('ORG_ID') IS NULL