ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFF83869E053B46B63588994Y select NAME,HIGH,LOW,AVERAGE,DET_HRS, HXT_HXT951A_XMLP_PKG.high1formula(TOT_HRS, HIGH) HIGH1, HXT_HXT951A_XMLP_PKG.low1formula(TOT_HRS, LOW) LOW1, HXT_HXT951A_XMLP_PKG.average1formula(TOT_HRS, AVERAGE) AVERAGE1 from ( SELECT ORG.NAME NAME, VAR.HIGH HIGH, VAR.LOW LOW, VAR.AVERAGE AVERAGE, NVL(DET.HOURS,0) DET_HRS, sum(NVL(DET.HOURS,0)) over (partition by ORG.NAME,VAR.HIGH,VAR.LOW,VAR.AVERAGE) TOT_HRS FROM HXT_VARIANCES VAR, HR_ORGANIZATION_UNITS ORG, 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='ORG1' and VAR.FCL_PERIOD = :period_type and VAR.ORGANIZATION_ID=ORG.ORGANIZATION_ID 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 ASM.ORGANIZATION_ID=VAR.ORGANIZATION_ID and ELTV.HXT_EARNING_CATEGORY in ('REG','OVT','ABS') ) HXT HXT951A_XML AR HXT احتساب تباين المنشأة Application: الوقت والعمالة Source: احتساب تباين المنشأة (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG D HXT Abweichungsberechnung Organisation Application: Time and Labor Source: Abweichungsberechnung Organisation (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG F HXT Calcul des écarts de l'organisation Application: Time and Labor Source: Calcul des écarts de l'organisation (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG US HXT Organization Variance Calc Application: Time and Labor Source: Organization Variance Calc (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG ZHS HXT 组织差异计算 Application: 时间和人工管理系统 Source: 组织差异计算 (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_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 终止日期