VIEW: APPS.HXT_DET_HOURS_WORKED_X

Source

View Text - Preformatted

SELECT ID ,PARENT_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_END_DATE ,EFFECTIVE_START_DATE ,JOB_ID ,EARN_POL_ID ,PREV_WAGE_CODE ,PROJECT_ID ,RETRO_PBL_LINE_ID ,PBL_LINE_ID ,RETRO_BATCH_ID ,PAY_STATUS ,PA_STATUS ,STATE_NAME ,COUNTY_NAME ,CITY_NAME ,ZIP_CODE ,OBJECT_VERSION_NUMBER FROM HXT_DET_HOURS_WORKED_F WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE) AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)

View Text - HTML Formatted

SELECT ID
, PARENT_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_END_DATE
, EFFECTIVE_START_DATE
, JOB_ID
, EARN_POL_ID
, PREV_WAGE_CODE
, PROJECT_ID
, RETRO_PBL_LINE_ID
, PBL_LINE_ID
, RETRO_BATCH_ID
, PAY_STATUS
, PA_STATUS
, STATE_NAME
, COUNTY_NAME
, CITY_NAME
, ZIP_CODE
, OBJECT_VERSION_NUMBER
FROM HXT_DET_HOURS_WORKED_F
WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)