ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5673869E053B46B63588994 select P.PARTY_CODE PTY_CODE, P.SHORT_NAME PTY_NAME from XTR_PARTIES_V P where (CROSS_REF_TO_OTHER_PARTY = nvl(:p_company,P.CROSS_REF_TO_OTHER_PARTY) and internal_pty = 'Y') and ( exists (select 1 from XTR_BANK_BALANCES_V B where B.BALANCE_DATE >= Nvl(:P_From,B.Balance_Date) and B.BALANCE_DATE <= Nvl(:P_To,B.Balance_Date) and nvl(b.interest_settled,0) != 0 and B.COMPANY_CODE = P.PARTY_CODE) or exists (select 1 from XTR_INTERGROUP_TRANSFERS_V T where Nvl(T.INTEREST_SETTLED,0) != 0 and T.TRANSFER_DATE >= Nvl(:P_From,T.Transfer_Date) and T.TRANSFER_DATE <= Nvl(:P_To,T.Transfer_Date) and T.PARTY_CODE = P.PARTY_CODE) ) Y XTR XTRIGINS_XML AR XTR بين الشركات - تقرير تسوية الفائدة (بتنسيق XML) Application: الخزانة Source: بين الشركات - تقرير تسوية الفائدة (بتنسيق XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG D XTR Zinsabrechnung - zwischenbetrieblich Application: Treasury Source: Zinsabrechnung - zwischenbetrieblich (XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG F XTR Intersociété - Etat Règlement des intérêts Application: Treasury Source: Intersociété - Etat Règlement des intérêts (XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG US XTR Intercompany - Interest Settlement Application: Treasury Source: Intercompany - Interest Settlement Report (XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG ZHS XTR 公司间 - 利息结算报表 Application: 理财管理系统 Source: 公司间 - 利息结算报表 (XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG BI Publisher :company_name_header :cp_para :mth_end :mth_end2 :p_company :p_conc_request_id :p_display_debug :p_from :p_from_date :p_from_date_1 :p_period_ending :p_sql_trace :p_to :p_to_date :p_to_date_1 :report_date :report_group :report_nos :report_short_name :report_short_name2 :use_defaults :version_num :z1company :z1end_of_month :z1parameters :z1report_nos :z2_from_date :z2_to_date :z2account :z2bank_account :z2end_of_report :z2for :z2int_settled :z2intergroup :z2intergroup_account :z2number :z2page :z2party_name :z2ref :z2report :z2requested_by :z2sum 1 10 :p_company LOV Oracle XTR_COMPANY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='C' order by party_code Y AR الشركة D Firma F Société US Company ZHS 公司 2 20 :p_from_date Date AR من تاريخ D Von Datum F Date de début US From Date ZHS 自日期 3 30 :p_to_date Date AR إلى تاريخ D Bis Datum F Date de fin US To Date ZHS 至日期