[Home] [Help]
2221: AND third_party_id = ln_supplier_id --variable: ln_supplier_id
2222: AND account_segment = lv_account_number --variable: lv_account_number
2223: AND period_name = pv_first_period --parameter: pv_first_period
2224: GROUP BY third_party_id, currency_code) bal,
2225: Fnd_Currencies_Vl Fcv
2226: WHERE bal.Functional_Amount <> 0
2227: AND Fcv.currency_code = bal.currency_code
2228: ORDER BY bal.currency_code;
2229:
2301:
2302: BEGIN
2303: SELECT Fcv.NAME Functional_Currency
2304: INTO lv_fun_currency
2305: FROM Gl_Ledgers Gl, Fnd_Currencies_Vl Fcv
2306: WHERE Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2307: AND Fcv.CURRENCY_CODE = Gl.Currency_Code;
2308: EXCEPTION
2309: WHEN NO_DATA_FOUND THEN
2657: Gl_Periods Gp,
2658: Xla_Ae_Lines Ael,
2659: Xla_Ae_Headers Aeh,
2660: Ap_Suppliers Sup,
2661: Fnd_Currencies_Vl Fcv
2662: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
2663: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
2664: AND Gir.Je_Line_Num = Jel.Je_Line_Num
2665: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id
2805: '' Remittance_Bill_Number
2806: FROM Ap_Invoices_All Aia,
2807: Pa_Projects_All Pap,
2808: Po_Headers_All Pha,
2809: Fnd_Currencies_Vl Fcv,
2810: Xla_Transaction_Entities Ent,
2811: Xla_Ae_Headers Aeh,
2812: Xla_Ae_Lines Ael,
2813: Gl_Je_Headers Jeh,
2893: Gl_Je_Headers Jeh,
2894: Gl_Import_References Gir,
2895: Pa_Projects_All Pap,
2896: Po_Headers_All Pha,
2897: Fnd_Currencies_Vl Fcv
2898: WHERE Aia.Invoice_Id = Aip.Invoice_Id
2899: AND Ach.Check_Id = Aip.Check_Id
2900: AND Aia.Invoice_Id = ln_invoice_id -- variable: ln_invoice_id
2901: AND Aip.Period_Name = lv_period_name --variable: lv_period_name
2979: Gl_Je_Headers Jeh,
2980: Gl_Import_References Gir,
2981: Pa_Projects_All Pap,
2982: Po_Headers_All Pha,
2983: Fnd_Currencies_Vl Fcv
2984: WHERE Aia.Invoice_Id = ln_invoice_id -- variable: ln_invoice_id
2985: --SLA condition
2986: AND Ent.Application_Id = 200
2987: AND Aia.Invoice_Id = Ent.Source_Id_Int_1