APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 977: FROM ap_invoice_distributions_all

973: charge_applicable_to_dist_id ,
974: cancellation_flag ,
975: match_status_flag ,
976: awt_invoice_payment_id
977: FROM ap_invoice_distributions_all
978: UNION
979: SELECT accounting_date ,
980: accounting_event_id ,
981: invoice_line_number,

Line 1701: UPDATE ap_invoice_distributions_all

1697: END IF;
1698:
1699:
1700: FORALL i IN l_inv_dist_tab.FIRST..l_inv_dist_tab.LAST
1701: UPDATE ap_invoice_distributions_all
1702: SET accounting_event_id = l_accounting_event_id
1703: WHERE line_type_lookup_code in ('REC_TAX','NONREC_TAX',
1704: 'TRV','TIPV','TERV') --Bug5455985
1705: AND accounting_event_id IS NULL

Line 2690: from ap_invoice_distributions_all

2686:
2687: --bug 7011943 There are payment time AWT dists.
2688: select count(*)
2689: into l_count
2690: from ap_invoice_distributions_all
2691: where accounting_event_id = l_accounting_event_ids(i)
2692: and invoice_id = l_event_source_info.source_id_int_1
2693: and awt_invoice_payment_id is not null;
2694:

Line 3312: from ap_invoice_distributions_all

3308: END IF;
3309: --bug 7011943
3310: select count(*)
3311: into l_count
3312: from ap_invoice_distributions_all
3313: where accounting_event_id = l_accounting_event_ids(i)
3314: and invoice_id = l_event_source_info.source_id_int_1
3315: and awt_invoice_payment_id is not null;
3316:

Line 4268: UPDATE ap_invoice_distributions_all D

4264: G_MODULE_NAME || l_procedure_name,
4265: l_log_msg);
4266: END IF;
4267:
4268: UPDATE ap_invoice_distributions_all D
4269: SET D.accounting_event_id = p_event_id
4270: WHERE D.accounting_event_id IS NULL
4271: AND D.invoice_id IN
4272: (SELECT AI.invoice_id

Line 4441: UPDATE ap_invoice_distributions_all AID

4437: /* Added for bug#8438184 Start */
4438:
4439: FORALL i IN 1 .. l_check_ids.count
4440:
4441: UPDATE ap_invoice_distributions_all AID
4442: SET AID.accounting_event_id = l_accounting_event_ids(i)
4443: WHERE AID.accounting_event_id IS NULL
4444: AND AID.invoice_id IN
4445: ( SELECT AI.invoice_id

Line 5315: FROM ap_invoice_distributions_all aid

5311: l_count := 0;
5312: BEGIN
5313: SELECT count(1)
5314: INTO l_count
5315: FROM ap_invoice_distributions_all aid
5316: WHERE aid.invoice_id = l_prepay_app_invoice_ids(i)
5317: AND aid.accounting_event_id = p_adj_accounting_event_id
5318: AND NOT EXISTS
5319: (SELECT 1

Line 6469: FROM ap_invoice_distributions_all AID,

6465: AID.invoice_id,
6466: AID.org_id,
6467: AI.legal_entity_id,
6468: AID.set_of_books_id ledger_id
6469: FROM ap_invoice_distributions_all AID,
6470: ap_invoices_all AI
6471: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
6472: = p_period_name
6473: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699

Line 6501: FROM ap_invoice_distributions_all AID,

6497: AID.invoice_id,
6498: AID.org_id,
6499: AI.legal_entity_id,
6500: AID.set_of_books_id ledger_id
6501: FROM ap_invoice_distributions_all AID,
6502: ap_invoices_all AI
6503: WHERE AID.accounting_date BETWEEN p_from_date AND p_to_date
6504: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
6505: AND aid.org_id = ai.org_id

Line 7819: FROM AP_Invoice_Distributions_All AID

7815: -- the Accounting Event ID
7816: --
7817: SELECT min(accounting_Event_id)
7818: INTO l_related_prepay_app_event_id
7819: FROM AP_Invoice_Distributions_All AID
7820: WHERE AID.line_type_lookup_code = 'PREPAY'
7821: AND nvl(AID.amount,0) < 0
7822: AND AID.invoice_id = P_invoice_id
7823: AND AID.invoice_line_number = P_invoice_line_number;

Line 8178: FROM ap_invoice_distributions_all aid,

8174:
8175: CURSOR reversed_prepay_events IS
8176: SELECT DISTINCT aid.invoice_id,
8177: aid.accounting_event_id
8178: FROM ap_invoice_distributions_all aid,
8179: ap_invoices_all ai
8180: WHERE ai.invoice_id = p_invoice_id
8181: AND aid.invoice_id = ai.invoice_id
8182: --AND ai.cancelled_date IS NOT NULL --bug9441420

Line 8190: FROM ap_invoice_distributions_all aid1

8186: AND NVL(aid.posted_flag, 'N') <> 'Y'
8187: AND NVL(aid.reversal_flag, 'N') = 'Y'
8188: AND EXISTS
8189: (SELECT 1
8190: FROM ap_invoice_distributions_all aid1
8191: WHERE aid1.invoice_id = aid.invoice_id
8192: AND aid1.line_type_lookup_code IN ('PREPAY','REC_TAX','NONREC_TAX')
8193: AND aid1.prepay_distribution_id IS NOT NULL
8194: AND aid1.accounting_event_id IS NOT NULL

Line 8203: FROM ap_invoice_distributions_all aid1

8199: NVL(aid.parent_reversal_id, aid.invoice_distribution_id))
8200: AND ((ai.cancelled_date IS NOT NULL AND
8201: NOT EXISTS
8202: (SELECT 1
8203: FROM ap_invoice_distributions_all aid1
8204: WHERE aid1.invoice_id = ai.invoice_id
8205: AND aid1.prepay_distribution_id IS NULL
8206: )
8207: ) OR --bug9441420 added OR clause

Line 8211: ap_invoice_distributions_all aid_prepay

8207: ) OR --bug9441420 added OR clause
8208: (NOT EXISTS
8209: (SELECT 1
8210: FROM ap_invoice_payments_all aip,
8211: ap_invoice_distributions_all aid_prepay
8212: WHERE aip.invoice_id = aid_prepay.invoice_id
8213: AND aid_prepay.invoice_distribution_id = aid.prepay_distribution_id
8214: AND nvl(aip.reversal_flag, 'N') = 'N'
8215: ))

Line 8221: FROM ap_invoice_distributions_all app_aid,

8217: /* RCA bug 14120800*/
8218: UNION
8219: SELECT app_aid.invoice_id,
8220: unapp_aid.accounting_Event_id unapp_event_id
8221: FROM ap_invoice_distributions_all app_aid,
8222: xla_events xe_app,
8223: ap_invoices_all ai,
8224: ap_invoice_distributions_all unapp_aid,
8225: xla_events xe_unapp

Line 8224: ap_invoice_distributions_all unapp_aid,

8220: unapp_aid.accounting_Event_id unapp_event_id
8221: FROM ap_invoice_distributions_all app_aid,
8222: xla_events xe_app,
8223: ap_invoices_all ai,
8224: ap_invoice_distributions_all unapp_aid,
8225: xla_events xe_unapp
8226: WHERE ai.invoice_id = p_invoice_id
8227: AND app_aid.prepay_distribution_id IS NOT NULL
8228: AND app_aid.accounting_event_id = xe_app.event_id