VIEW: APPS.CE_FORECAST_PAY_ORGS_V

Source

View Text - Preformatted

SELECT DISTINCT 'PAY' , BG.BUSINESS_GROUP_ID , BG.NAME , PAY.GL_SET_OF_BOOKS_ID , GL.NAME , NVL(GL.CURRENCY_CODE, BG.CURRENCY_CODE) , GL.DESCRIPTION , to_number(NULL) /* to_number(HRO.LEGAL_ENTITY_ID)*/ FROM PAY_ALL_PAYROLLS_F PAY, CE_HR_BUS_GRPS_V BG, GL_SETS_OF_BOOKS GL WHERE PAY.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID AND PAY.GL_SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID UNION ALL SELECT DISTINCT 'PAY' , BG.BUSINESS_GROUP_ID , BG.NAME , PAY.GL_SET_OF_BOOKS_ID , NULL , BG.CURRENCY_CODE , NULL , to_number(NULL) FROM PAY_ALL_PAYROLLS_F PAY, CE_HR_BUS_GRPS_V BG WHERE PAY.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID AND PAY.GL_SET_OF_BOOKS_ID IS NULL

View Text - HTML Formatted

SELECT DISTINCT 'PAY'
, BG.BUSINESS_GROUP_ID
, BG.NAME
, PAY.GL_SET_OF_BOOKS_ID
, GL.NAME
, NVL(GL.CURRENCY_CODE
, BG.CURRENCY_CODE)
, GL.DESCRIPTION
, TO_NUMBER(NULL) /* TO_NUMBER(HRO.LEGAL_ENTITY_ID)*/
FROM PAY_ALL_PAYROLLS_F PAY
, CE_HR_BUS_GRPS_V BG
, GL_SETS_OF_BOOKS GL
WHERE PAY.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID
AND PAY.GL_SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID UNION ALL SELECT DISTINCT 'PAY'
, BG.BUSINESS_GROUP_ID
, BG.NAME
, PAY.GL_SET_OF_BOOKS_ID
, NULL
, BG.CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
FROM PAY_ALL_PAYROLLS_F PAY
, CE_HR_BUS_GRPS_V BG
WHERE PAY.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID
AND PAY.GL_SET_OF_BOOKS_ID IS NULL