ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2A13869E053B46B63588994Y SELECT nvl(uncst.org_id, -99) uncst_org_id, uncst.set_of_books_id uncst_sob, 'UnCosted Exceptions' unCst_warnings, uncst.pa_period_name Period_unCst, uncst.exception_reason Exception_Reason_unCst, uncst.denom_currency_code uncost_denom_currency_code, COUNT(*) unCst_ei_Lines, SUM(uncst.acct_burdened_amount) Total_acct_amount_unCst, SUM(uncst.denom_burdened_amount) Total_denom_amount_uncst, uncst.corrective_action Corrective_Action_Cst, PA_PAXEXCPS_XMLP_PKG.cf_uncst_ou_nameformula(nvl ( uncst.org_id , - 99 )) CF_uncst_ou_name, PA_PAXEXCPS_XMLP_PKG.cf_uncst_sob_nameformula(uncst.set_of_books_id) CF_uncst_sob_name FROM pa_gl_uncost_except_sum_v uncst, pa_implementations imp WHERE :calling_mode = 'PA' AND nvl(imp.org_id,-99) = nvl(uncst.org_id,-99) and uncst.set_of_books_id = imp.set_of_books_id and ( (uncst.system_linkage_function <> 'PJ' and uncst.expenditure_item_date BETWEEN :start_date AND :end_date) OR ( uncst.system_linkage_function = 'PJ' and NVL(uncst.prvdr_accrual_date,uncst.expenditure_item_date ) BETWEEN :start_date AND :end_date ) ) and ( nvl(fnd_profile.VALUE_SPECIFIC('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'N' OR (nvl(fnd_profile.VALUE_SPECIFIC('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'Y' and (nvl(imp.same_pa_gl_period,'N') in ('N', 'Y')) ) ) GROUP BY uncst.org_id,uncst.set_of_books_id ,3, uncst.pa_period_name, uncst.exception_reason, uncst.denom_currency_code, uncst.corrective_action UNION SELECT nvl(uncst.org_id, -99) uncst_org_id, uncst.set_of_books_id uncst_sob, 'UnCosted Exceptions' unCst_warnings, uncst.period_name Period_unCst, uncst.exception_reason Exception_Reason_unCst, uncst.denom_currency_code uncost_denom_currency_code, COUNT(*) unCst_ei_Lines, SUM(uncst.acct_burdened_amount) Total_acct_amount_unCst, SUM(uncst.denom_burdened_amount) Total_denom_amount_uncst, uncst.corrective_action Corrective_Action_Cst --ADDED ,PA_PAXEXCPS_XMLP_PKG.cf_uncst_ou_nameformula(nvl ( uncst.org_id , - 99 )) CF_uncst_ou_name, PA_PAXEXCPS_XMLP_PKG.cf_uncst_sob_nameformula(uncst.set_of_books_id) CF_uncst_sob_name FROM pa_gl_uncost_except_sum_v uncst WHERE :calling_mode = 'GL' and ( (uncst.system_linkage_function <> 'PJ' and uncst.expenditure_item_date BETWEEN :start_date AND :end_date) OR ( uncst.system_linkage_function = 'PJ' and NVL(uncst.prvdr_accrual_date,uncst.expenditure_item_date ) BETWEEN :start_date AND :end_date ) ) and nvl(fnd_profile.VALUE_SPECIFIC('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'Y' and nvl(uncst.same_pa_gl_period ,'N') in ('N', 'Y') and ( :across_ous = 'Y' OR ( :across_ous = 'N' and nvl(uncst.org_id ,-99) = ( select nvl(paimp.org_id,-99) from pa_implementations paimp) ) ) GROUP BY uncst.org_id,uncst.set_of_books_id ,3, uncst.period_name, uncst.exception_reason, uncst.denom_currency_code, uncst.corrective_action PA PAXEXCPS_XML AR PA إجمالي استثناء الحركات حسب فترة محاسبة المشروعات (بتنسيق XML) Application: المشروعات Source: EXC: إجمالي استثناء الحركات حسب فترة محاسبة المشروعات (بتنسيق XML) Short Name: PAXEXCPS_XML DB package: PA_PAXEXCPS_XMLP_PKG D PA Transaktionsausnahmen - Übersicht nach PA-Periode Application: Projects Source: AUS: Transaktionsausnahmen - Übersicht nach PA-Periode (XML) Short Name: PAXEXCPS_XML DB package: PA_PAXEXCPS_XMLP_PKG F PA Synthèse des anomalies de mouvement par période PA Application: Projects Source: EXC : Synthèse des anomalies de mouvement par période PA (XML) Short Name: PAXEXCPS_XML DB package: PA_PAXEXCPS_XMLP_PKG US PA Transaction Exception Summary by PA Period Application: Projects Source: EXC: Transaction Exception Summary by PA Period (XML) Short Name: PAXEXCPS_XML DB package: PA_PAXEXCPS_XMLP_PKG ZHS PA EXC：按 PA 期间列出的事务处理例外汇总 Application: 项目 Source: EXC：按 PA 期间列出的事务处理例外汇总 (XML) Short Name: PAXEXCPS_XML DB package: PA_PAXEXCPS_XMLP_PKG BI Publisher :across_ous :c_company_name_header :c_dummy_data :c_no_data_found :calling_mode :cp_ou_name :end_date :end_period :operating_unit :org_id1 :p_conc_request_id :p_debug_mode :p_min_precision :p_rule_optimizer :start_date :start_period 1 10 :start_period LOV Oracle PA_SRS_EXCPS_PERIOD Y select period_name id, period_name value, null description from pa_periods where status in ('O','F','W') order by end_date Y AR من فترة محاسبة المشروعات D Von PA-Periode F Période PA - De US From PA Period ZHS 自 PA 期间 2 20 :end_period LOV Oracle PA_SRS_EXCPS_PERIOD Y select period_name id, period_name value, null description from pa_periods where status in ('O','F','W') order by end_date Y AR إلى فترة محاسبة المشروعات D Bis PA-Periode F Période PA - A US To PA Period ZHS 至 PA 期间