View: PA_SRS_COST_BATCH_NAME_V

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

View Text

SELECT DISTINCT JEB.NAME JE_BATCH_NAME
FROM GL_JE_CATEGORIES CAT
, GL_JE_HEADERS JEH
, PA_SYSTEM_LINKAGES SYS
, GL_JE_SOURCES JES
, 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 = SYS.COST_JE_CATEGORY_NAME(+)

Columns