View: HXT_BATCH_STATUS_FMV

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_BATCH_STATUS_FMV

View Text

SELECT PBH.BATCH_ID
, PBH.BUSINESS_GROUP_ID
, PBH.BATCH_NAME
, PBH.BATCH_REFERENCE
, PAY.PAYROLL_NAME
, PAY.PAYROLL_ID
, PTP.END_DATE
, FCL.MEANING BATCH_STATUS
FROM PER_TIME_PERIODS PTP
, PAY_PAYROLLS PAY
, HXT_BATCH_STATES HBS
, PAY_BATCH_HEADERS PBH
, HR_LOOKUPS FCL
WHERE PBH.BATCH_ID = HBS.BATCH_ID
AND PTP.PAYROLL_ID = (SELECT DISTINCT TIM1.PAYROLL_ID
FROM HXT_TIMECARDS TIM1
WHERE TIM1.BATCH_ID = PBH.BATCH_ID)
AND PAY.PAYROLL_ID = PTP.PAYROLL_ID
AND PAY.BUSINESS_GROUP_ID = PBH.BUSINESS_GROUP_ID
AND FCL.APPLICATION_ID = 808
AND FCL.LOOKUP_TYPE = 'HXT_BATCH_STATUS'
AND FCL.LOOKUP_CODE = HBS.STATUS
AND PTP.TIME_PERIOD_ID = (SELECT DISTINCT TIM2.TIME_PERIOD_ID
FROM HXT_TIMECARDS TIM2
WHERE TIM2.BATCH_ID = PBH.BATCH_ID)

Columns