View: HXTFV_SUM_HOURS_WORKED

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

View Text

SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HRW.DATE_WORKED DATE_WORKED
, HRW.LINE_STATUS LINE_STATUS
, HRW.HOURS HOURS
, HRW.TIME_IN TIME_IN
, HRW.TIME_OUT TIME_OUT
, HRW.AMOUNT AMOUNT
, HRW.HOURLY_RATE HOURLY_RATE
, HRW.HRW_COMMENT HRW_COMMENT
, HRW.RATE_MULTIPLE RATE_MULTIPLE
, HR_GENERAL.DECODE_LOOKUP('PAY_PDT_VDPO'
, HRW.FCL_TAX_RULE_CODE) TAX_RULE
, HR_GENERAL.DECODE_LOOKUP('ELE_ENTRY_REASON'
, HRW.FCL_EARN_REASON_CODE) EARN_REASON
, HRW.SEPARATE_CHECK_FLAG SEPARATE_CHECK
, HRW.SEQNO SEQUENCE_NUMBER
, HRW.ACTUAL_TIME_IN ACTUAL_TIME_IN
, HRW.ACTUAL_TIME_OUT ACTUAL_TIME_OUT
, HRW.PREV_WAGE_CODE PREV_WAGE_CODE
, HRW.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ERP.NAME EARNING_POLICY
, ELTT.ELEMENT_NAME ELEMENT_NAME
, SHT.NAME SHIFT_NAME
, NVL(HRW_LOCT.LOCATION_CODE
, ASG_LOCT.LOCATION_CODE) LOCATION_CODE
, TTASK.TASK_NUMBER TASK_NUMBER
, TTASK.NAME TASK_NAME
, TPROJ.PRO_NUMBER PROJECT_NUMBER
, TPROJ.NAME PROJECT_NAME
, '_KF:PAY:COST:CKEY' /********/ /* IDS */ /********/
, HRW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HRW.FFV_COST_CENTER_ID COST_CENTER_ID
, HRW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, HRW.EARN_POL_ID EARNING_POLICY_ID
, ASG.GRADE_ID GRADE_ID
, HRW.JOB_ID JOB_ID
, HRW.FFV_LABOR_ACCOUNT_ID LABOR_ACCOUNT_ID
, NVL(HRW.LOCATION_ID
, ASG.LOCATION_ID) LOCATION_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, HRW.PROJECT_ID PROJECT_ID
, HRW.SHT_ID SHIFT_ID
, HRW.ID SUM_HOURS_WORKED_ID
, HRW.TAS_ID TASK_ID
, HRW.TIM_ID TIMECARD_ID
FROM PAY_COST_ALLOCATION_KEYFLEX CKEY
, HXT_SUM_HOURS_WORKED_F HRW
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_ELEMENT_TYPES_F_TL ELTT
, HXT_EARNING_POLICIES ERP
, HR_LOCATIONS_ALL_TL HRW_LOCT
, HR_LOCATIONS_ALL_TL ASG_LOCT
, HXT_PROJECTS TPROJ
, HXT_TASKS TTASK
, HXT_SHIFTS SHT
WHERE HRW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND CKEY.COST_ALLOCATION_KEYFLEX_ID (+) = HRW.FFV_COST_CENTER_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND HRW.PROJECT_ID = TPROJ.ID(+)
AND HRW.TAS_ID = TTASK.ID(+)
AND HRW.SHT_ID = SHT.ID(+)
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND HRW.ELEMENT_TYPE_ID = ELTT.ELEMENT_TYPE_ID(+)
AND HRW.EARN_POL_ID = ERP.ID
AND HRW.LOCATION_ID = HRW_LOCT.LOCATION_ID(+)
AND ASG.LOCATION_ID = ASG_LOCT.LOCATION_ID(+)
AND ASG_LOCT.LANGUAGE(+) = USERENV('LANG')
AND HRW_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ELTT.LANGUAGE(+) = USERENV('LANG')
AND HRW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND HRW.DATE_WORKED BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN HRW.EFFECTIVE_START_DATE
AND HRW.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ERP.EFFECTIVE_START_DATE
AND ERP.EFFECTIVE_END_DATE WITH READ ONLY

Columns