View: HXT_TIM_SUMMARY_FMV

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

View Text

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)

Columns