View: HXT_ADD_ASSIGN_INFO_D

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

View Text

SELECT AAI.ID
, AAI.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_END_DATE
, ASG.ASSIGNMENT_NUMBER
, HRK1.MEANING AUTOGEN_HOURS_YN
, ROT.NAME ROTATION_PLAN_NAME
, ERP.NAME EARNING_POLICY_NAME
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY_NAME
, HDP.NAME HOUR_DEDUCTION_POLICY_NAME
, AAI.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_EARNING_POLICIES ERP
, HXT_ROTATION_PLANS ROT
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AAI
, FND_USER FUSER
, HR_LOOKUPS HRK1
WHERE AAI.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND AAI.EFFECTIVE_START_DATE BETWEEN NVL(ASG.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_START_DATE)
AND NVL(ASG.EFFECTIVE_END_DATE
, AAI.EFFECTIVE_END_DATE)
AND AAI.EFFECTIVE_START_DATE BETWEEN NVL(HRK1.START_DATE_ACTIVE(+)
, AAI.EFFECTIVE_START_DATE)
AND NVL(HRK1.END_DATE_ACTIVE(+)
, AAI.EFFECTIVE_END_DATE)
AND HRK1.LOOKUP_TYPE = 'YES_NO'
AND HRK1.ENABLED_FLAG = 'Y'
AND HRK1.APPLICATION_ID = 800
AND HRK1.LOOKUP_CODE = AAI.AUTOGEN_HOURS_YN
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(+)
AND AAI.LAST_UPDATED_BY = FUSER.USER_ID(+)

Columns