ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F28D3869E053B46B63588994Y SELECT hz_p.party_name customer_name, hz_p.party_number customer_number, ag.agreement_id, SUBSTR(ag.agreement_num,1,20) agreement_number, ag.agreement_type, ag.amount revenue_amt, ag.expiration_date, f.meaning revenue_limit, ag.amount - sum(nvl(pfs.total_baselined_amount,0)) amount_not_allocated, sum(nvl(pfs.total_accrued_amount,0)) revenue_accrued, sum(nvl(pfs.total_billed_amount,0)) amount_invoiced, sum(nvl(pfs.total_baselined_amount,0)) - sum(nvl(pfs.total_accrued_amount,0)) revenue_backlog, ag.agreement_currency_code agreement_currency_code, substr(hr.name,1,60) name, f1.meaning invoice_limit FROM fnd_lookups f, fnd_lookups f1, pa_summary_project_fundings pfs, pa_agreements ag, hz_parties hz_p, hz_cust_accounts hz_c, hr_organization_units hr WHERE hz_c.cust_account_id = nvl(:cust, hz_c.cust_account_id) and hz_c.party_id = hz_p.party_id and f.lookup_type = 'YES_NO' and f.lookup_code = ag.revenue_limit_flag and f1.lookup_type = 'YES_NO' and f1.lookup_code = ag.invoice_limit_flag and ag.owning_organization_id = hr.organization_id(+) and hz_c.cust_account_id = ag.customer_id and ag.agreement_num = nvl(:agree, ag.agreement_num) and ag.agreement_id = pfs.agreement_id GROUP BY hz_p.party_name, hz_p.party_number, ag.agreement_id, ag.agreement_num, ag.agreement_type, ag.amount, ag.expiration_date, f.meaning, ag.agreement_currency_code, hr.name, f1.meaning order by customer_name,customer_number,agreement_currency_code, hz_p.party_name, decode(:sort,'EXPIRATION DATE', ag.expiration_date), decode(:sort,'AGREEMENT NUMBER',ag.agreement_num), decode(:sort, 'REVENUE LIMIT', ag.amount, 'AMOUNT NOT ALLOCATED', ag.amount - sum(nvl(pfs.total_baselined_amount,0)), 'REVENUE BACKLOG', sum(nvl(pfs.total_baselined_amount,0)) - sum(nvl(pfs.total_accrued_amount,0))) PA PAXAGAST_XML AR PA موقف الاتفاقية حسب العميل (بتنسيق XML) Application: المشروعات Source: MGT: موقف الاتفاقية حسب العميل (بتنسيق XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG D PA Vertragsstatus nach Kunde Application: Projects Source: PA: Vertragsstatus nach Kunde (XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG F PA Statut des accords-cadres par client Application: Projects Source: MGT : Statut des accords-cadres par client (XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG US PA Agreement Status By Customer Application: Projects Source: MGT: Agreement Status By Customer (XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG ZHS PA MGT：按客户列出的协议状态 Application: 项目 Source: MGT：按客户列出的协议状态 (XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG BI Publisher :agree :c_company_name_header :c_customer_name :c_sort :cust :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :sort 1 10 :sort LOV Oracle PA_SRS_AGREEMENT_SORT Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='AGREEMENT SORT TYPES' order by meaning select meaning from pa_lookups where lookup_type = 'AGREEMENT SORT TYPES' AND LOOKUP_CODE = 'AGREEMENT NUMBER' Y AR فرز حسب D Sortieren nach F Tri par US Sort By ZHS 排序依据 2 20 :cust LOV Oracle PA_SRS_PROJECT_CUSTOMERS Y select customer_id id, cust_name_and_number value, null description from pa_customer_lov_v "PC" where (nvl(pc.site_use_code,'BILL_TO')<>'SHIP_TO' or not exists (select null from pa_customer_lov_v pc1 where pc1.customer_id=pc.customer_id and nvl(pc1.site_use_code,'BILL_TO')<>'SHIP_TO')) order by customer_name AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 3 30 :agree LOV Oracle PA_SRS_AGREEMENT_NUM Y Y select a.agreement_num id, a.agreement_num value, p.party_name description from pa_agreements a,hz_cust_accounts c,hz_parties p where a.customer_id=c.cust_account_id and c.party_id=p.party_id order by a.agreement_num,p.party_name AR رقم الاتفاقية D Vertragsnummer F Numéro d'accord-cadre US Agreement Number ZHS 协议编号