[Home] [Help]
145: DECODE(SIGN(SUM(APAD.Base_Amount - APAD.Base_Amt_At_Prepay_XRate)),
146: -1, 'G', 1, 'L',
147: 0, l_gain_loss_indicator_parent)) -- bug9175969
148: FROM AP_Prepay_App_Dists APAD,
149: AP_System_Parameters_ALL ASP
150: WHERE ASP.Org_ID = APH.Org_ID
151: AND APAD.Prepay_History_ID = APH.Prepay_History_ID
152: AND APAD.Accounting_Event_ID = p_xla_event_rec.event_id
153: AND APAD.PREPAY_DIST_LOOKUP_CODE NOT IN ('FINAL PAYMENT ROUNDING',
468: SELECT SUM(amount), count(1)
469: FROM ap_invoice_distributions_all aid,
470: xla_events evnt,
471: xla_ae_headers xah,
472: ap_system_parameters_all asp
473: WHERE aid.accounting_event_id = p_acct_event_id
474: AND aid.accounting_event_id = evnt.event_id
475: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',
476: 'DEBIT MEMO ADJUSTED','PREPAYMENT ADJUSTED') -- 12731687
549: l_historical_flag,
550: l_upg_batch_id
551: FROM ap_prepay_history_all APPH,
552: xla_ae_headers XAH,
553: ap_system_parameters_all ASP
554: WHERE APPH.Invoice_ID = P_Invoice_ID
555: AND APPH.accounting_event_id = l_prepay_hist_rec.related_prepay_app_event_id
556: AND XAH.application_id = 200
557: AND XAH.event_id = APPH.accounting_event_id
758: --FROM AP_Invoice_Payments_All AIP
759: --WHERE Invoice_ID = p_invoice_id
760: --AND EXISTS (SELECT 'Upg Payment'
761: -- FROM AP_Payment_History_All APH,
762: -- AP_System_Parameters_All ASP,
763: -- XLA_AE_Headers XAH
764: -- WHERE APH.Check_ID = AIP.Check_ID
765: -- AND APH.Historical_Flag = 'Y'
766: -- AND APH.Posted_Flag = 'Y'
939:
940: -- bug 7611160
941: SELECT asp.base_currency_code
942: INTO ap_accounting_pay_pkg.g_base_currency_code
943: FROM ap_system_parameters_all asp,
944: ap_invoices_all ai
945: WHERE asp.org_id = ai.org_id
946: AND ai.invoice_id = l_inv_rec.invoice_id;
947:
3413: '-2222' GAIN_OR_LOSS_REF,
3414: APAD.Invoice_Distribution_ID,
3415: APAD.Prepay_Dist_Lookup_Code
3416: FROM AP_Invoices_All AI,
3417: AP_System_Parameters_All ASP,
3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,
3421: AP_Invoice_Distributions_All AID,
3515: '-2222' GAIN_OR_LOSS_REF,
3516: APAD.Invoice_Distribution_ID,
3517: APAD.Prepay_Dist_Lookup_Code
3518: FROM AP_Invoices_All AI,
3519: AP_System_Parameters_All ASP,
3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,
3523: AP_Invoice_Distributions_All AID,