VIEW: APPS.HXT_BATCH_STATUS_FMV

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)