ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5683869E053B46B63588994Y Select COMPANY, PTY, CCY , TRANS_DATE, TRANSACTION_NUMBER, N_DAYS, ACC_INT_BF , PRIN_ACTION, PRIN_ADJUST, BAL_OUT, INT_CALC, INT_RATE, SET_DATE, int_set, rounding_type, day_count_type, rounding_factor, ig_year_basis, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER) CF_PRV_DAY, XTR_XTRIGSUM_XMLP_PKG.bal_bfformula(COMPANY, PTY, CCY, TRANS_DATE) BAL_BF, XTR_XTRIGSUM_XMLP_PKG.cf_prv_rateformula(COMPANY, PTY, CCY, TRANS_DATE) CF_PRV_RATE, XTR_XTRIGSUM_XMLP_PKG.cf_interest_for_dummy_recformu(XTR_XTRIGSUM_XMLP_PKG.cf_no_of_daysformula(N_DAYS, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER), TRANS_DATE), rounding_factor, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER), TRANS_DATE, XTR_XTRIGSUM_XMLP_PKG.bal_bfformula(COMPANY, PTY, CCY, TRANS_DATE), XTR_XTRIGSUM_XMLP_PKG.cf_prv_rateformula(COMPANY, PTY, CCY, TRANS_DATE), rounding_type) CF_interest_for_dummy_rec, XTR_XTRIGSUM_XMLP_PKG.cf_int_cfformula(COMPANY, PTY, CCY, XTR_XTRIGSUM_XMLP_PKG.cf_interest_for_dummy_recformu(XTR_XTRIGSUM_XMLP_PKG.cf_no_of_daysformula(N_DAYS, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER), TRANS_DATE), rounding_factor, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER), TRANS_DATE, XTR_XTRIGSUM_XMLP_PKG.bal_bfformula(COMPANY, PTY, CCY, TRANS_DATE), XTR_XTRIGSUM_XMLP_PKG.cf_prv_rateformula(COMPANY, PTY, CCY, TRANS_DATE), rounding_type), day_count_type, ACC_INT_BF) CF_int_Cf, XTR_XTRIGSUM_XMLP_PKG.cf_no_of_daysformula(N_DAYS, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER), TRANS_DATE) CF_no_of_days from ( select company_code COMPANY ,party_code PTY ,currency CCY ,transfer_date TRANS_DATE ,transaction_number TRANSACTION_NUMBER ,no_of_days N_DAYS ,interest_settled ACC_INT_BF ,principal_action PRIN_ACTION ,Decode(Principal_action,'REC',(-1)*principal_adjust,principal_adjust) PRIN_ADJUST ,balance_out BAL_OUT ,interest INT_CALC ,interest_rate INT_RATE ,settle_date SET_DATE ,decode(settle_date,Null,0,accum_interest_bf) int_set ,rounding_type ,day_count_type from XTR_INTERGROUP_TRANSFERS_V where party_code like nvl(upper(:SEL_PARTY2),party_code) and company_code like nvl(upper(:SEL_COMP2),company_code) and transfer_date between nvl(:PER_FROM, transfer_date) and :PER_TO AND COMPANY_CODE IN( SELECT xca.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc WHERE company_code = xca.party_code AND xca.dealer_code = xdc.dealer_code AND xca.company_authorised_for_input = 'Y' AND xdc.user_id = fnd_global.user_id) UNION select company_code ,party_code ,currency ,:Per_To ,transaction_number+1 ,:Per_To - Transfer_Date ,0 ,'DUMMY' ,0 ,balance_out ,0 ,interest_rate ,transfer_date ,0 ,rounding_type ,day_count_type /*, XTR_XTRIGSUM_XMLP_PKG.cf_prv_dayformula(COMPANY, PTY, CCY, TRANS_DATE, TRANSACTION_NUMBER) CF_PRV_DAY, XTR_XTRIGSUM_XMLP_PKG.bal_bfformula(COMPANY, PTY, CCY, TRANS_DATE) BAL_BF, XTR_XTRIGSUM_XMLP_PKG.cf_prv_rateformula(COMPANY, PTY, CCY, TRANS_DATE) CF_PRV_RATE, XTR_XTRIGSUM_XMLP_PKG.cf_interest_for_dummy_recformu(:CF_no_of_days, rounding_factor, ig_year_basis, day_count_type, SET_DATE, PTY, COMPANY, CCY, PRIN_ACTION, :CF_PRV_DAY, TRANS_DATE, :BAL_BF, :CF_PRV_RATE, rounding_type) CF_interest_for_dummy_rec, XTR_XTRIGSUM_XMLP_PKG.cf_int_cfformula(COMPANY, PTY, CCY, :CF_interest_for_dummy_rec, day_count_type, ACC_INT_BF) CF_int_Cf, XTR_XTRIGSUM_XMLP_PKG.cf_no_of_daysformula(N_DAYS, ig_year_basis, day_count_type, transfer_date, party_code, company_code, currency, 'DUMMY', :CF_PRV_DAY, TRANS_DATE) CF_no_of_days*/ from XTR_INTERGROUP_TRANSFERS_V , ( Select Comp_Code, CParty_Code, Curr, Trans_Date, max(Transaction_number) trans_no From Xtr_InterGroup_Transfers_V a, ( Select Company_Code Comp_Code , Party_Code CParty_Code , Currency Curr , Max(transfer_date) Trans_Date, min(:per_to - transfer_date) min_diff From Xtr_InterGroup_Transfers_V where party_code like nvl(upper(:sel_party2),party_code) and company_code like nvl(upper(:sel_comp2),company_code) and transfer_date <= :Per_To AND COMPANY_CODE IN( SELECT xca.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc WHERE company_code = xca.party_code AND xca.dealer_code = xdc.dealer_code AND xca.company_authorised_for_input = 'Y' and xdc.user_id = fnd_global.user_id) Group by Company_Code , Party_Code , Currency ) q where a.company_code = q.comp_code and a.party_code = q.cparty_code and a.currency = q.curr and a.transfer_date = q.trans_date and q.min_diff <> 0 group by comp_Code,CParty_Code,curr,trans_Date ) q where party_code = q.Cparty_Code and company_code =q.Comp_Code and currency = q.curr and transfer_date = q.trans_date and transaction_number = q.trans_no ) j, xtr_master_currencies_v v Where j.ccy = v.currency order by 1,2,3,4 asc,5 asc XTR XTRIGSUM_XML AR XTR بين الشركات - كشوف الحسابات (بتنسيق XML) Application: الخزانة Source: بين الشركات - كشوف الحسابات (بتنسيق XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG D XTR Kontoauszüge - zwischenbetrieblich Application: Treasury Source: Kontoauszüge - zwischenbetrieblich (XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG F XTR Intersociété - Relevés Application: Treasury Source: Intersociété - Relevés (XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG US XTR Intercompany - Statements Application: Treasury Source: Intercompany - Statements (XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG ZHS XTR 公司间 - 对帐单 Application: 理财管理系统 Source: 公司间 - 对帐单 (XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG BI Publisher :company_name_header :cp_para :input_from_date :input_to_date :p_combination :p_company :p_conc_request_id :p_display_debug :p_intamt_running :p_intergroup_party :p_oldest_transfer_date :p_period_from :p_period_from_1 :p_period_to :p_period_to_1 :p_prev_day_count_type :p_prev_prev_day_count_type :p_setamt_running :p_sql_trace :per_from :per_to :report_date :report_group :report_nos :report_short_name :report_short_name2 :sel_comp :sel_comp2 :sel_party :sel_party2 :use_defaults :version_num :z1company :z1for_period :z1intergroup_party :z1parameters :z1report_nos :z1to :z2adjustment :z2balance :z2ccy :z2currency :z2date :z2day :z2end_of_report :z2int_rate :z2interest :z2interest_bfwd :z2interest_cfwd :z2interest_for_the_period :z2interest_settled :z2note :z2page :z2prin :z2report :z2requested_by :z2settled_on 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 AR الشركة D Firma F Société US Company ZHS 公司 2 20 :p_intergroup_party LOV Oracle XTR_INTERGROUP_PARTY_COMSUB Y select party_code id, party_code value, short_name description from xtr_parties_v where (party_type='CP' and cross_ref_to_other_party=:$flex$.xtr_company and internal_pty='Y') or (party_type='C' and party_code<>:$flex$.xtr_company) order by party_code AR الطرف بين الشركات D Zwischenbetriebliche Partei F Partie intersociété US Intercompany Party ZHS 子公司 3 30 :p_period_from Date AR فترة من D Von Periode F Période - De US Period From ZHS 期间自 4 40 :p_period_to Date AR فترة إلى D Bis Periode F Période - A US Period To ZHS 终止期间