View: HXT_SUM_HOURS_WORKED_D

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

View Text

SELECT HRW.ID
, HRW.EFFECTIVE_START_DATE
, HRW.EFFECTIVE_END_DATE
, HRW.DATE_WORKED
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT
, HRW.HOURS
, TO_CHAR(HRW.TIME_IN
, 'HH24MI') TIME_IN
, TO_CHAR(HRW.TIME_OUT
, 'HH24MI') TIME_OUT
, ELTT.ELEMENT_NAME
, ERP.NAME EARNING_POLICY
, HRW.AMOUNT
, HRW.HOURLY_RATE
, HRL.MEANING REASON
, PCAK.CONCATENATED_SEGMENTS COST_CENTER
, TPROJ.PROJECT_NUMBER
, TTASK.TASK_NUMBER
, LOCT.LOCATION_CODE LOCATION_CODE
, HRW.HRW_COMMENT
, HRW.RATE_MULTIPLE
, FCL.MEANING TAX_RULE
, HRW.SEPARATE_CHECK_FLAG
, HRW.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
, HRW.PREV_WAGE_CODE
, SHT.NAME SHIFT_NAME
FROM HXT_SUM_HOURS_WORKED_F HRW
, PER_ASSIGNMENTS_F ASG
, PAY_ELEMENT_TYPES_F ELT
, PAY_ELEMENT_TYPES_F_TL ELTT
, HXT_EARNING_POLICIES ERP
, HR_LOOKUPS HRL
, PAY_COST_ALLOCATION_KEYFLEX PCAK
, HXT_PROJECTS_V TPROJ
, HXT_TASKS_V TTASK
, HR_LOCATIONS_ALL_TL LOCT
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOOKUPS FCL
, HXT_SHIFTS SHT
, FND_USER_VIEW FUSER
WHERE HRW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND HRW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND HRW.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID(+)
AND HRW.DATE_WORKED BETWEEN NVL(ELT.EFFECTIVE_START_DATE
, HRW.DATE_WORKED)
AND NVL(ELT.EFFECTIVE_END_DATE
, HRW.DATE_WORKED)
AND ELTT.ELEMENT_TYPE_ID(+) = ELT.ELEMENT_TYPE_ID
AND DECODE(ELTT.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTT.LANGUAGE) = DECODE(ELTT.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND HRW.EARN_POL_ID = ERP.ID
AND HRW.DATE_WORKED BETWEEN NVL(HRL.START_DATE_ACTIVE
, HRW.DATE_WORKED)
AND NVL(HRL.END_DATE_ACTIVE
, HRW.DATE_WORKED)
AND HRL.LOOKUP_TYPE(+) = 'ELE_ENTRY_REASON'
AND HRL.LOOKUP_CODE(+) = HRW.FCL_EARN_REASON_CODE
AND PCAK.COST_ALLOCATION_KEYFLEX_ID(+) = HRW.FFV_COST_CENTER_ID
AND HRW.PROJECT_ID = TPROJ.PROJECT_ID(+)
AND HRW.TAS_ID = TTASK.TASK_ID(+)
AND HRW.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.LOCATION_ID = LOCT.LOCATION_ID(+)
AND DECODE(LOCT.LOCATION_ID
, NULL
, '1'
, LOCT.LANGUAGE) = DECODE(LOCT.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND HRW.FCL_TAX_RULE_CODE = FCL.LOOKUP_CODE(+)
AND FCL.APPLICATION_ID(+)=800
AND FCL.LOOKUP_TYPE(+)='PAY_PDT_VDPO'
AND FCL.ENABLED_FLAG(+) = 'Y'
AND HRW.DATE_WORKED BETWEEN NVL(FCL.START_DATE_ACTIVE
, HRW.DATE_WORKED)
AND NVL(FCL.END_DATE_ACTIVE
, HRW.DATE_WORKED)
AND HRW.SHT_ID = SHT.ID(+)
AND HRW.LAST_UPDATED_BY = FUSER.USER_ID(+)

Columns