[Home] [Help]
296:
297: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
298: SELECT SUM(amount), count(1)
299: FROM ap_invoice_distributions_all aid,
300: xla_events evnt,
301: ap_system_parameters_all asp
302: WHERE aid.accounting_event_id = p_acct_event_id
303: AND aid.accounting_event_id = evnt.event_id
304: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',
631: AND aid.prepay_distribution_id IS NULL
632: AND (aid.awt_invoice_payment_id IS NULL OR
633: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
634: AND NOT EXISTS
635: (SELECT 1 FROM xla_events
636: WHERE event_id = aid.accounting_event_id
637: AND application_id = 200
638: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
639: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));
991: AND aid.prepay_distribution_id IS NULL
992: AND (aid.awt_invoice_payment_id IS NULL OR
993: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
994: AND NOT EXISTS
995: (SELECT 1 FROM xla_events
996: WHERE event_id = aid.accounting_event_id
997: AND application_id = 200
998: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
999: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));
1547: AND aid.prepay_distribution_id IS NULL
1548: AND (aid.awt_invoice_payment_id IS NULL OR
1549: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
1550: AND NOT EXISTS
1551: (SELECT 1 FROM xla_events
1552: WHERE event_id = aid.accounting_event_id
1553: AND application_id = 200
1554: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
1555: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));
2069: AND (AID.AWT_Invoice_Payment_ID IS NULL
2070: OR AID.AWT_Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id)
2071: -- bug fix: 6725866
2072: AND NOT EXISTS (SELECT 1
2073: FROM xla_events
2074: WHERE event_id = AID.accounting_event_id
2075: AND application_id = 200 -- bug7281412
2076: AND event_type_code IN ('INVOICE CANCELLED',
2077: 'PREPAYMENT CANCELLED',
2107: WHERE AID.invoice_id = p_inv_rec.invoice_id
2108: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT')
2109: AND AID.Prepay_Distribution_ID IS NULL
2110: AND NOT EXISTS (SELECT 1
2111: FROM xla_events
2112: WHERE event_id = AID.accounting_event_id
2113: AND application_id = 200 --bug 7281412
2114: AND event_type_code IN ('INVOICE CANCELLED',
2115: 'PREPAYMENT CANCELLED',
4654: aid_xe.entity_id aid_Entity_id
4655: FROM AP_Checks_All AC,
4656: AP_System_Parameters_All ASP,
4657: XLA_Transaction_Entities_Upg XTE,
4658: XLA_Events XLE,
4659: AP_Payment_History_All APH,
4660: XLA_AE_Headers AEH,
4661: XLA_AE_Lines AEL,
4662: AP_Inv_Dists_Source AID1,
4662: AP_Inv_Dists_Source AID1,
4663: AP_Invoices_All AI,
4664: AP_Invoice_Distributions_All AID,
4665: AP_Payment_Hist_Dists APHD,
4666: xla_events aid_xe -- changed for bug#7293021
4667: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
4668: AND AC.Org_ID = ASP.Org_ID
4669: AND XLE.Event_ID = p_accounting_event_id
4670: AND ASP.Set_Of_Books_ID = XTE.Ledger_ID
4733: aid_xe.entity_id aid_Entity_id --- changed for bug#7293021
4734: FROM AP_Checks_All AC,
4735: AP_System_Parameters_All ASP,
4736: XLA_Transaction_Entities_Upg XTE,
4737: XLA_Events XLE,
4738: AP_Payment_History_All APH,
4739: XLA_AE_Headers AEH,
4740: XLA_AE_Lines AEL,
4741: AP_Payment_Hist_Dists APHD,
4740: XLA_AE_Lines AEL,
4741: AP_Payment_Hist_Dists APHD,
4742: AP_Invoice_Distributions_All AID,
4743: AP_Invoices_All AI,
4744: xla_events aid_xe -- changed for bug#7293021
4745: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
4746: AND AC.Org_ID = ASP.Org_ID
4747: AND XLE.Event_ID = p_accounting_event_id
4748: AND ASP.Set_Of_Books_ID = XTE.Ledger_ID