View: HXTFV_PROJECT_ACCOUNTING

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

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
, PRO.NAME PROJECT_NAME
, PRO.PRO_NUMBER PROJECT_NUMBER
, PRO.DESCRIPTION PROJECT_DESCRIPTION
, PRO.DATE_FROM PROJECT_START
, PRO.DATE_TO PROJECT_END
, ORGT.NAME ORGANIZATION_NAME
, TAS.NAME TASK_NAME
, TAS.DESCRIPTION TASK_DESCRIPTION
, TAS.ESTIMATED_TIME TASK_ESTIMATED_TIME
, HR_GENERAL.DECODE_LOOKUP('HXT_TASK_UNITS'
, TAS.FCL_UNITS) TASK_UNITS
, TAS.TASK_NUMBER TASK_NUMBER
, TAS.DATE_FROM TASK_START
, TAS.DATE_TO TASK_END
, DHW.DATE_WORKED DATE_WORKED
, DHW.HOURS HOURS
, DHW.TIME_IN TIME_IN
, DHW.TIME_OUT TIME_OUT
, DHW.HRW_COMMENT HRW_COMMENT
, DHW.RATE_MULTIPLE RATE_MULTIPLE
, DHW.HOURLY_RATE HOURLY_RATE
, DHW.AMOUNT AMOUNT /*******/ /* IDS */ /*******/
, DHW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DHW.ID DET_HOURS_WORKED_ID
, DHW.EARN_POL_ID EARNING_POLICY_ID
, DHW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DHW.JOB_ID JOB_ID
, DHW.LOCATION_ID LOCATION_ID
, PRO.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, TAS.PRO_ID PROJECT_ID
, DHW.SHT_ID SHIFT_ID
, DHW.PARENT_ID SUM_HOURS_WORKED_ID
, DHW.TIM_ID TIMECARD_ID
, DHW.TAS_ID TASK_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_DET_HOURS_WORKED_F DHW
, HXT_TASKS TAS
, HXT_PROJECTS PRO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE SYSDATE BETWEEN DHW.EFFECTIVE_START_DATE
AND DHW.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = DHW.ASSIGNMENT_ID
AND DHW.TAS_ID = TAS.ID
AND TAS.PRO_ID = PRO.ID
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND PRO.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns