VIEW: APPS.CE_FORECAST_PA_ORGS_V

Source

View Text - Preformatted

SELECT 'PA', PA.ORG_ID, HRO.NAME, PA.SET_OF_BOOKS_ID, GL.NAME, GL.CURRENCY_CODE, GL.DESCRIPTION, to_number(NULL) /* to_number(HRO.LEGAL_ENTITY_ID)*/ FROM PA_IMPLEMENTATIONS_ALL PA, HR_OPERATING_UNITS HRO, GL_SETS_OF_BOOKS GL WHERE GL.SET_OF_BOOKS_ID = PA.SET_OF_BOOKS_ID AND PA.ORG_ID = HRO.ORGANIZATION_ID UNION ALL SELECT 'PA', PA.ORG_ID, NULL, PA.SET_OF_BOOKS_ID, GL.NAME, GL.CURRENCY_CODE, GL.DESCRIPTION, to_number(NULL) FROM PA_IMPLEMENTATIONS_ALL PA, GL_SETS_OF_BOOKS GL WHERE GL.SET_OF_BOOKS_ID = PA.SET_OF_BOOKS_ID AND PA.org_id IS NULL

View Text - HTML Formatted

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