VIEW: APPS.HXT_ADD_ASSIGN_INFO_FMV

Source

View Text - Preformatted

SELECT aai.rowid row_id ,aai.id ,aai.effective_start_date ,aai.effective_end_date ,peo.full_name ,aai.assignment_id ,asg.assignment_number ,asg.business_group_id asg_bus_grp_id ,aai.autogen_hours_yn ,hrlk.meaning autogen_hours_YN_MEANING ,aai.rotation_plan ,rot.name rotation_plan_name ,aai.earning_policy ,erp.name earning_policy_name ,aai.shift_differential_policy ,sdp.name shift_differential_policy_name ,aai.hour_deduction_policy ,hdp.name hour_deduction_policy_name ,aai.created_by ,aai.creation_date ,aai.last_update_date ,aai.last_update_login ,aai.last_updated_by ,aai.attribute_category ,aai.attribute1 ,aai.attribute2 ,aai.attribute3 ,aai.attribute4 ,aai.attribute5 ,aai.attribute6 ,aai.attribute7 ,aai.attribute8 ,aai.attribute9 ,aai.attribute10 ,aai.attribute11 ,aai.attribute12 ,aai.attribute13 ,aai.attribute14 ,aai.attribute15 ,aai.attribute16 ,aai.attribute17 ,aai.attribute18 ,aai.attribute19 ,aai.attribute20 ,aai.attribute21 ,aai.attribute22 ,aai.attribute23 ,aai.attribute24 ,aai.attribute25 ,aai.attribute26 ,aai.attribute27 ,aai.attribute28 ,aai.attribute29 ,aai.attribute30 FROM hxt_hour_deduct_policies hdp, hxt_shift_diff_policies sdp, hxt_earning_policies erp, hxt_rotation_plans rot, per_people_f peo, per_assignments_f asg, hr_lookups hrlk, hxt_add_assign_info_f aai, fnd_sessions fss WHERE fss.session_id = USERENV('SESSIONID') AND fss.effective_date between aai.effective_start_date and aai.effective_end_date AND aai.assignment_id = asg.assignment_id AND fss.effective_date between asg.effective_start_date and asg.effective_end_date AND asg.person_id = peo.person_id AND fss.effective_date between peo.effective_start_date and peo.effective_end_date AND aai.autogen_hours_yn = hrlk.lookup_code AND hrlk.application_id = 800 AND hrlk.lookup_type = 'YES_NO' AND aai.rotation_plan = rot.id(+) AND aai.earning_policy = erp.id AND aai.shift_differential_policy = sdp.id(+) AND aai.hour_deduction_policy = hdp.id(+)

View Text - HTML Formatted

SELECT AAI.ROWID ROW_ID
, AAI.ID
, AAI.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_END_DATE
, PEO.FULL_NAME
, AAI.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER
, ASG.BUSINESS_GROUP_ID ASG_BUS_GRP_ID
, AAI.AUTOGEN_HOURS_YN
, HRLK.MEANING AUTOGEN_HOURS_YN_MEANING
, AAI.ROTATION_PLAN
, ROT.NAME ROTATION_PLAN_NAME
, AAI.EARNING_POLICY
, ERP.NAME EARNING_POLICY_NAME
, AAI.SHIFT_DIFFERENTIAL_POLICY
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY_NAME
, AAI.HOUR_DEDUCTION_POLICY
, HDP.NAME HOUR_DEDUCTION_POLICY_NAME
, AAI.CREATED_BY
, AAI.CREATION_DATE
, AAI.LAST_UPDATE_DATE
, AAI.LAST_UPDATE_LOGIN
, AAI.LAST_UPDATED_BY
, AAI.ATTRIBUTE_CATEGORY
, AAI.ATTRIBUTE1
, AAI.ATTRIBUTE2
, AAI.ATTRIBUTE3
, AAI.ATTRIBUTE4
, AAI.ATTRIBUTE5
, AAI.ATTRIBUTE6
, AAI.ATTRIBUTE7
, AAI.ATTRIBUTE8
, AAI.ATTRIBUTE9
, AAI.ATTRIBUTE10
, AAI.ATTRIBUTE11
, AAI.ATTRIBUTE12
, AAI.ATTRIBUTE13
, AAI.ATTRIBUTE14
, AAI.ATTRIBUTE15
, AAI.ATTRIBUTE16
, AAI.ATTRIBUTE17
, AAI.ATTRIBUTE18
, AAI.ATTRIBUTE19
, AAI.ATTRIBUTE20
, AAI.ATTRIBUTE21
, AAI.ATTRIBUTE22
, AAI.ATTRIBUTE23
, AAI.ATTRIBUTE24
, AAI.ATTRIBUTE25
, AAI.ATTRIBUTE26
, AAI.ATTRIBUTE27
, AAI.ATTRIBUTE28
, AAI.ATTRIBUTE29
, AAI.ATTRIBUTE30
FROM HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_EARNING_POLICIES ERP
, HXT_ROTATION_PLANS ROT
, PER_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HR_LOOKUPS HRLK
, HXT_ADD_ASSIGN_INFO_F AAI
, FND_SESSIONS FSS
WHERE FSS.SESSION_ID = USERENV('SESSIONID')
AND FSS.EFFECTIVE_DATE BETWEEN AAI.EFFECTIVE_START_DATE
AND AAI.EFFECTIVE_END_DATE
AND AAI.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND FSS.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.PERSON_ID = PEO.PERSON_ID
AND FSS.EFFECTIVE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND AAI.AUTOGEN_HOURS_YN = HRLK.LOOKUP_CODE
AND HRLK.APPLICATION_ID = 800
AND HRLK.LOOKUP_TYPE = 'YES_NO'
AND AAI.ROTATION_PLAN = ROT.ID(+)
AND AAI.EARNING_POLICY = ERP.ID
AND AAI.SHIFT_DIFFERENTIAL_POLICY = SDP.ID(+)
AND AAI.HOUR_DEDUCTION_POLICY = HDP.ID(+)