VIEW: APPS.PA_SRS_REV_BATCH_NAME_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'