VIEW: APPS.HXT_TIM_SUMMARY_FMV

Source

View Text - Preformatted

SELECT asg.organization_id, asg.business_group_id asg_bus_grp_id, org.name organization_name, org.business_group_id org_bus_grp_id, asgv.hxt_rotation_plan hxt_rotation_plan_id, ptp.end_date, ppf.payroll_id, ppf.payroll_name, ppf.business_group_id pay_bus_grp_id, per.employee_number, per.full_name, per.business_group_id emp_bus_grp_id, tim.approv_person_id, per2.full_name approv_person_name, per2.business_group_id app_bus_grp_id, tim.approved_timestamp, rot.name rotation_plan_name, per.person_id, tim.id tim_id, tim.time_period_id, tim.rowid tim_row_id, tim.created_by, tim.creation_date, tim.last_update_date, tim.last_update_login, tim.last_updated_by from per_people_f per, per_time_periods ptp, hxt_timecards tim, per_assignments asg, hxt_per_aei_ddf_v asgv, hxt_rotation_plans rot, hr_organization_units org, per_people_f per2, pay_payrolls_f ppf WHERE per.person_id = tim.for_person_id and tim.time_period_id = ptp.time_period_id and ptp.end_date between per.effective_start_date and per.effective_end_date and ptp.end_date between asg.effective_start_date and asg.effective_end_date and asgv.assignment_id = asg.assignment_id and ptp.end_date between asgv.effective_start_date and asgv.effective_end_date and asg.person_id = per.person_id and asgv.hxt_rotation_plan = rot.id and org.organization_id = asg.organization_id and tim.payroll_id = ppf.payroll_id and tim.approv_person_id = per2.person_id(+) and ptp.end_date between nvl(per2.effective_start_date, hr_general.start_of_time) and nvl(per2.effective_end_date, hr_general.end_of_time)

View Text - HTML Formatted

SELECT ASG.ORGANIZATION_ID
, ASG.BUSINESS_GROUP_ID ASG_BUS_GRP_ID
, ORG.NAME ORGANIZATION_NAME
, ORG.BUSINESS_GROUP_ID ORG_BUS_GRP_ID
, ASGV.HXT_ROTATION_PLAN HXT_ROTATION_PLAN_ID
, PTP.END_DATE
, PPF.PAYROLL_ID
, PPF.PAYROLL_NAME
, PPF.BUSINESS_GROUP_ID PAY_BUS_GRP_ID
, PER.EMPLOYEE_NUMBER
, PER.FULL_NAME
, PER.BUSINESS_GROUP_ID EMP_BUS_GRP_ID
, TIM.APPROV_PERSON_ID
, PER2.FULL_NAME APPROV_PERSON_NAME
, PER2.BUSINESS_GROUP_ID APP_BUS_GRP_ID
, TIM.APPROVED_TIMESTAMP
, ROT.NAME ROTATION_PLAN_NAME
, PER.PERSON_ID
, TIM.ID TIM_ID
, TIM.TIME_PERIOD_ID
, TIM.ROWID TIM_ROW_ID
, TIM.CREATED_BY
, TIM.CREATION_DATE
, TIM.LAST_UPDATE_DATE
, TIM.LAST_UPDATE_LOGIN
, TIM.LAST_UPDATED_BY
FROM PER_PEOPLE_F PER
, PER_TIME_PERIODS PTP
, HXT_TIMECARDS TIM
, PER_ASSIGNMENTS ASG
, HXT_PER_AEI_DDF_V ASGV
, HXT_ROTATION_PLANS ROT
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PER2
, PAY_PAYROLLS_F PPF
WHERE PER.PERSON_ID = TIM.FOR_PERSON_ID
AND TIM.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PTP.END_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PTP.END_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASGV.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PTP.END_DATE BETWEEN ASGV.EFFECTIVE_START_DATE
AND ASGV.EFFECTIVE_END_DATE
AND ASG.PERSON_ID = PER.PERSON_ID
AND ASGV.HXT_ROTATION_PLAN = ROT.ID
AND ORG.ORGANIZATION_ID = ASG.ORGANIZATION_ID
AND TIM.PAYROLL_ID = PPF.PAYROLL_ID
AND TIM.APPROV_PERSON_ID = PER2.PERSON_ID(+)
AND PTP.END_DATE BETWEEN NVL(PER2.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(PER2.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME)