SELECT ID ,LINE_STATUS ,TIM_ID ,DATE_WORKED ,ASSIGNMENT_ID ,HOURS ,TIME_IN ,TIME_OUT ,ELEMENT_TYPE_ID ,FCL_EARN_REASON_CODE ,FFV_COST_CENTER_ID ,FFV_LABOR_ACCOUNT_ID ,TAS_ID ,LOCATION_ID ,SHT_ID ,HRW_COMMENT ,FFV_RATE_CODE_ID ,RATE_MULTIPLE ,HOURLY_RATE ,AMOUNT ,FCL_TAX_RULE_CODE ,SEPARATE_CHECK_FLAG ,SEQNO ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,ACTUAL_TIME_IN ,ACTUAL_TIME_OUT ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,PROJECT_ID ,PREV_WAGE_CODE ,JOB_ID ,EARN_POL_ID ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE21 ,ATTRIBUTE22 ,ATTRIBUTE23 ,ATTRIBUTE24 ,ATTRIBUTE25 ,ATTRIBUTE26 ,ATTRIBUTE27 ,ATTRIBUTE28 ,ATTRIBUTE29 ,ATTRIBUTE30 , OBJECT_VERSION_NUMBER ,TIME_BUILDING_BLOCK_ID ,TIME_BUILDING_BLOCK_OVN FROM HXT_SUM_HOURS_WORKED_F WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE) AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
SELECT ID
, LINE_STATUS
, TIM_ID
, DATE_WORKED
, ASSIGNMENT_ID
, HOURS
, TIME_IN
, TIME_OUT
, ELEMENT_TYPE_ID
, FCL_EARN_REASON_CODE
, FFV_COST_CENTER_ID
, FFV_LABOR_ACCOUNT_ID
, TAS_ID
, LOCATION_ID
, SHT_ID
, HRW_COMMENT
, FFV_RATE_CODE_ID
, RATE_MULTIPLE
, HOURLY_RATE
, AMOUNT
, FCL_TAX_RULE_CODE
, SEPARATE_CHECK_FLAG
, SEQNO
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACTUAL_TIME_IN
, ACTUAL_TIME_OUT
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PROJECT_ID
, PREV_WAGE_CODE
, JOB_ID
, EARN_POL_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, OBJECT_VERSION_NUMBER
, TIME_BUILDING_BLOCK_ID
, TIME_BUILDING_BLOCK_OVN
FROM HXT_SUM_HOURS_WORKED_F
WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
|
|
|