View: PA_SRS_REV_BATCH_NAME_V

Product:	PA - Projects
Description:	View used by SRS to select Journal Entry Batch names in GL created by Revenue programs - Retrofitted
Implementation/DBA Data:	APPS.PA_SRS_REV_BATCH_NAME_V

View Text

SELECT DISTINCT JEB.NAME JE_BATCH_NAME
FROM GL_JE_CATEGORIES CAT
, GL_JE_SOURCES JES
, GL_JE_HEADERS JEH
, GL_JE_BATCHES JEB
WHERE JEB.JE_BATCH_ID = JEH.JE_BATCH_ID
AND JES.JE_SOURCE_NAME = 'PROJECT ACCOUNTING'
AND JEB.NAME LIKE JES.USER_JE_SOURCE_NAME || '%'
AND JEH.JE_CATEGORY = CAT.JE_CATEGORY_NAME
AND CAT.JE_CATEGORY_NAME = 'REVENUE'

Columns