VIEW: APPS.HXT_BATCH_REFERENCE_V

Source

View Text - Preformatted

SELECT DISTINCT PBH.BATCH_REFERENCE, PBH.BUSINESS_GROUP_ID FROM PAY_BATCH_HEADERS PBH, HXT_BATCH_STATES HBS WHERE PBH.BATCH_REFERENCE IS NOT NULL AND HBS.BATCH_ID = PBH.BATCH_ID AND HBS.STATUS in ('VV', 'VW') AND EXISTS (SELECT 'Y' FROM HXT_DET_HOURS_WORKED DET WHERE DET.RETRO_BATCH_ID = HBS.BATCH_ID AND DET.RETRO_BATCH_ID IS NOT NULL)

View Text - HTML Formatted

SELECT DISTINCT PBH.BATCH_REFERENCE
, PBH.BUSINESS_GROUP_ID
FROM PAY_BATCH_HEADERS PBH
, HXT_BATCH_STATES HBS
WHERE PBH.BATCH_REFERENCE IS NOT NULL
AND HBS.BATCH_ID = PBH.BATCH_ID
AND HBS.STATUS IN ('VV'
, 'VW')
AND EXISTS (SELECT 'Y'
FROM HXT_DET_HOURS_WORKED DET
WHERE DET.RETRO_BATCH_ID = HBS.BATCH_ID
AND DET.RETRO_BATCH_ID IS NOT NULL)