ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFF93869E053B46B63588994 select LOCATION_CODE,LOCATION_ID,HIGH,LOW,AVERAGE,DET_HRS, HXT_HXT952A_XMLP_PKG.high1formula(TOT_HRS, HIGH) HIGH1, HXT_HXT952A_XMLP_PKG.low1formula(TOT_HRS, LOW) LOW1, HXT_HXT952A_XMLP_PKG.average1formula(TOT_HRS, AVERAGE) AVERAGE1 from ( SELECT loct.LOCATION_CODE LOCATION_CODE, VAR.LOCATION_ID LOCATION_ID, VAR.HIGH HIGH, VAR.LOW LOW, VAR.AVERAGE AVERAGE, NVL(DET.HOURS,0) DET_HRS, sum(NVL(DET.HOURS,0)) over (partition by loct.LOCATION_CODE,VAR.LOCATION_ID,VAR.HIGH,VAR.LOW,VAR.AVERAGE) TOT_HRS FROM HXT_VARIANCES VAR, HR_LOCATIONS_ALL_TL LOCT, HR_LOCATIONS_NO_JOIN LOC, PAY_ELEMENT_TYPES_F ELT, HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV, HXT_DET_HOURS_WORKED_X DET, PER_ASSIGNMENTS_F ASM WHERE VAR.VAR_TYPE='LOC1' and VAR.FCL_PERIOD = :period_type and VAR.LOCATION_ID=LOC.LOCATION_ID AND loc.location_id = loct.location_id(+) AND decode(loct.location_id,null,'1',loct.language) = decode(loct.location_id,null,'1',userenv('LANG')) and DET.ASSIGNMENT_ID=ASM.ASSIGNMENT_ID and DET.DATE_WORKED between ASM.EFFECTIVE_START_DATE and ASM.EFFECTIVE_END_DATE and ELT.ELEMENT_TYPE_ID=DET.ELEMENT_TYPE_ID and DET.DATE_WORKED between ELT.EFFECTIVE_START_DATE and ELT.EFFECTIVE_END_DATE and ELT.ELEMENT_TYPE_ID = ELTV.ELEMENT_TYPE_ID and DET.DATE_WORKED between ELTV.EFFECTIVE_START_DATE and ELTV.EFFECTIVE_END_DATE and ELTV.HXT_EARNING_CATEGORY in ('REG','OVT','ABS') ) Y HXT HXT952A_XML AR HXT العملية الحسابية لتباين الموقع Application: الوقت والعمالة Source: العملية الحسابية لتباين الموقع (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG D HXT Abweichungsberechnung Standort Application: Time and Labor Source: Abweichungsberechnung Standort (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG F HXT Calcul des écarts de lieu Application: Time and Labor Source: Calcul des écarts de lieu (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG US HXT Location Variance Calculation Application: Time and Labor Source: Location Variance Calculation (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG ZHS HXT 地点差异计算 Application: 时间和人工管理系统 Source: 地点差异计算 (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG BI Publisher :end_date :end_date1 :p_conc_request_id :period_type :start_date :start_date1 1 10 :period_type LOV Oracle HXT_VARIANCE_PERIOD Y select fcl.lookup_code id, fcl.meaning value, null description from hr_lookups fcl where lookup_type='HXT_VARIANCE_PERIOD' and application_id=808 and enabled_flag='Y' order by fcl.lookup_type Y AR نوع الفترة D Periodenart F Type de période US Period Type ZHS 期间类型 2 20 :start_date Date AR تاريخ البداية D Startdatum F Date de début US Start Date ZHS 起始日期 3 30 :end_date Date AR تاريخ النهاية D Enddatum F Date de fin US End Date ZHS 终止日期