VIEW: APPS.PA_SRS_COST_BATCH_NAME_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)