View: HXTFV_DET_HOURS_WORKED

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_DET_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
, DHW.DATE_WORKED DATE_WORKED
, DHW.LINE_STATUS LINE_STATUS
, DHW.HOURS HOURS
, DHW.TIME_IN TIME_IN
, DHW.TIME_OUT TIME_OUT
, DHW.AMOUNT AMOUNT
, DHW.HOURLY_RATE HOURLY_RATE
, DHW.HRW_COMMENT HRW_COMMENT
, DHW.RATE_MULTIPLE RATE_MULTIPLE
, HR_GENERAL.DECODE_LOOKUP('PAY_PDT_VDPO'
, DHW.FCL_TAX_RULE_CODE) TAX_RULE
, HR_GENERAL.DECODE_LOOKUP('ELE_ENTRY_REASON'
, DHW.FCL_EARN_REASON_CODE) EARN_REASON
, DHW.SEPARATE_CHECK_FLAG SEPARATE_CHECK
, DHW.SEQNO SEQUENCE_NUMBER
, DHW.ACTUAL_TIME_IN ACTUAL_TIME_IN
, DHW.ACTUAL_TIME_OUT ACTUAL_TIME_OUT
, DHW.PREV_WAGE_CODE PREV_WAGE_CODE
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ERP.NAME EARNING_POLICY
, ELTT.ELEMENT_NAME ELEMENT_NAME
, SHT.NAME SHIFT_NAME
, NVL(DHW_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
, DHW.PA_STATUS PA_STATUS
, HR_GENERAL.DECODE_LOOKUP('PAY_STATUS'
, DHW.PAY_STATUS) PAY_STATUS /********/ /* IDS */ /********/
, DHW.ID DET_HOURS_WORKED_ID
, DHW.PARENT_ID SUM_HOURS_WORKED_ID
, DHW.TIM_ID TIMECARD_ID
, DHW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, DHW.JOB_ID JOB_ID
, DHW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DHW.EARN_POL_ID EARNING_POLICY_ID
, DHW.FFV_COST_CENTER_ID COST_CENTER_ID
, DHW.FFV_LABOR_ACCOUNT_ID LABOR_ACCOUNT_ID
, DHW.FFV_RATE_CODE_ID RATE_CODE_ID
, DHW.PROJECT_ID PROJECT_ID
, DHW.TAS_ID TASK_ID
, NVL(DHW.LOCATION_ID
, ASG.LOCATION_ID) LOCATION_ID
, DHW.SHT_ID SHIFT_ID
, DHW.RETRO_PBL_LINE_ID RETRO_LINE_ID
, DHW.RETRO_BATCH_ID RETRO_BATCH_ID
, DHW.PBL_LINE_ID PBL_LINE_ID
FROM HXT_DET_HOURS_WORKED_F DHW
, 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 ASG_LOCT
, HR_LOCATIONS_ALL_TL DHW_LOCT
, HXT_PROJECTS TPROJ
, HXT_TASKS TTASK
, HXT_SHIFTS SHT
WHERE DHW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND DHW.PROJECT_ID = TPROJ.ID(+)
AND DHW.TAS_ID = TTASK.ID(+)
AND DHW.SHT_ID = SHT.ID(+)
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID )
AND DHW.ELEMENT_TYPE_ID = ELTT.ELEMENT_TYPE_ID(+)
AND DHW.EARN_POL_ID = ERP.ID (+)
AND DHW.LOCATION_ID = DHW_LOCT.LOCATION_ID(+)
AND ASG.LOCATION_ID = ASG_LOCT.LOCATION_ID(+)
AND DHW_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ASG_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ELTT.LANGUAGE(+) = USERENV('LANG')
AND DHW.DATE_WORKED BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND DHW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN DHW.EFFECTIVE_START_DATE
AND DHW.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ERP.EFFECTIVE_START_DATE (+)
AND ERP.EFFECTIVE_END_DATE (+) WITH READ ONLY

Columns