View: BEN_BATCH_MONITOR_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_BATCH_MONITOR_V

View Text

SELECT BFT.BENEFIT_ACTION_ID
, FND.REQUEST_ID
, CONC.USER_CONCURRENT_PROGRAM_NAME
, BFT.BUSINESS_GROUP_ID
, FND.STATUS_CODE
, FND1.MEANING
FROM FND_CONCURRENT_PROGRAMS_TL CONC
, FND_LOOKUPS FND1
, FND_CONCURRENT_REQUESTS FND
, BEN_BENEFIT_ACTIONS BFT
WHERE FND.REQUEST_ID = BFT.REQUEST_ID
AND CONC.CONCURRENT_PROGRAM_ID = FND.CONCURRENT_PROGRAM_ID
AND FND1.LOOKUP_TYPE = 'CP_STATUS_CODE'
AND FND1.LOOKUP_CODE = FND.STATUS_CODE

Columns