View: HXT_SUM_HOURS_WORKED_FMV

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

View Text

SELECT HRW.ROWID ROW_ID
, HRW.ID
, HRW.EFFECTIVE_START_DATE
, HRW.EFFECTIVE_END_DATE
, HRW.TIM_ID
, HRW.DATE_WORKED
, HRW.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASG.BUSINESS_GROUP_ID ASG_BUS_GRP_ID
, HRW.HOURS
, HRW.TIME_IN
, HRW.TIME_OUT
, HRW.ELEMENT_TYPE_ID
, ELTT.ELEMENT_NAME
, HRW.EARN_POL_ID
, ERP.NAME EARNING_POLICY
, HRW.AMOUNT
, HRW.HOURLY_RATE
, HRW.FCL_EARN_REASON_CODE
, HRL.MEANING REASON
, HRW.FFV_COST_CENTER_ID
, PCAK.CONCATENATED_SEGMENTS COST_CENTER
, HRW.PROJECT_ID
, TPROJ.SEGMENT1 PROJECT_NUMBER
, HRW.TAS_ID
, TTASK.TASK_NUMBER
, HRW.LOCATION_ID
, LOCT.LOCATION_CODE LOCATION_CODE
, HRW.HRW_COMMENT
, HRW.FFV_RATE_CODE_ID
, HRW.RATE_MULTIPLE
, HRW.FCL_TAX_RULE_CODE
, FCL.MEANING TAX_RULE
, HRW.SEPARATE_CHECK_FLAG
, HRW.SEQNO
, HRW.CREATED_BY
, HRW.CREATION_DATE
, HRW.LAST_UPDATE_DATE
, HRW.LAST_UPDATE_LOGIN
, HRW.LAST_UPDATED_BY
, HRW.ACTUAL_TIME_IN
, HRW.ACTUAL_TIME_OUT
, HRW.PREV_WAGE_CODE
, HRW.SHT_ID
, SHT.NAME SHIFT_NAME
, HRW.ATTRIBUTE1
, HRW.ATTRIBUTE2
, HRW.ATTRIBUTE3
, HRW.ATTRIBUTE4
, HRW.ATTRIBUTE5
, HRW.ATTRIBUTE6
, HRW.ATTRIBUTE7
, HRW.ATTRIBUTE8
, HRW.ATTRIBUTE9
, HRW.ATTRIBUTE10
, HRW.ATTRIBUTE11
, HRW.ATTRIBUTE12
, HRW.ATTRIBUTE13
, HRW.ATTRIBUTE14
, HRW.ATTRIBUTE15
, HRW.ATTRIBUTE16
, HRW.ATTRIBUTE17
, HRW.ATTRIBUTE18
, HRW.ATTRIBUTE19
, HRW.ATTRIBUTE20
, HRW.ATTRIBUTE21
, HRW.ATTRIBUTE22
, HRW.ATTRIBUTE23
, HRW.ATTRIBUTE24
, HRW.ATTRIBUTE25
, HRW.ATTRIBUTE26
, HRW.ATTRIBUTE27
, HRW.ATTRIBUTE28
, HRW.ATTRIBUTE29
, HRW.ATTRIBUTE30
, HRW.ATTRIBUTE_CATEGORY
, HRW.STATE_NAME
, HRW.COUNTY_NAME
, HRW.CITY_NAME
, HRW.ZIP_CODE
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
, PA_PROJECTS_ALL TPROJ
, PA_TASKS TTASK
, HR_LOCATIONS_ALL_TL LOCT
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOOKUPS FCL
, HXT_SHIFTS SHT
, FND_USER_VIEW FUSER
WHERE HRW.EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND HRW.EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND 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