[Home] [Help]
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