APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 251: ,ap_invoice_distributions_all aid

247: ,G_SRC_TYP_UNACCT_DISTS
248: ,G_SRC_TAB_AP_INV_DISTS_ALL
249: from
250: ap_invoices_all ai
251: ,ap_invoice_distributions_all aid
252: ,ap_org_attributes_gt org_gtt
253: where
254: ai.invoice_id = aid.invoice_id
255: and ( aid.accounting_date between g_period_start_date and g_period_end_date)

Line 296: ,ap_invoice_distributions_all aid

292: ,aid.invoice_line_number
293: ,G_SRC_TYP_UNACCT_DISTS
294: ,G_SRC_TAB_AP_INV_DISTS_ALL
295: from ap_invoices_all ai
296: ,ap_invoice_distributions_all aid
297: ,ap_org_attributes_gt org_gtt
298: where ai.invoice_id = aid.invoice_id
299: and ( aid.accounting_date between g_period_start_date and g_period_end_date)
300: and aid.posted_flag in ('N' , 'S', 'P')

Line 485: from ap_invoice_distributions_all aid

481: where
482: ai.invoice_id = ail.invoice_id
483: and (ail.accounting_date between g_period_start_date and g_period_end_date)
484: and not exists (select /*+ nl_aj */ 1 --> lines without distributions
485: from ap_invoice_distributions_all aid
486: where aid.invoice_id = ail.invoice_id
487: and aid.invoice_line_number = ail.line_number
488: and aid.org_id = org_gtt.org_id
489: )

Line 885: ,ap_invoice_distributions_all aid

881: ,xla_events_unacct(i).entity_code
882: ,G_SRC_TYP_OTHER_EXCPS
883: ,G_SRC_TAB_AP_INV_DISTS_ALL
884: FROM ap_invoices_all ai
885: ,ap_invoice_distributions_all aid
886: ,ap_org_attributes_gt org_gtt
887: WHERE aid.invoice_id = ai.invoice_id(+)
888: AND aid.set_of_books_id = g_ledger_id
889: AND aid.org_id = org_gtt.org_id

Line 1634: from ap_invoice_distributions_all

1630:
1631: if p_context = 'INV' then
1632: /* select count(*) --commented this peice of code 7318763
1633: into l_count
1634: from ap_invoice_distributions_all
1635: where accounting_event_id = p_event_id
1636: and invoice_id = p_trans_id
1637: and awt_invoice_payment_id is not null; */
1638:

Line 2078: UPDATE ap_invoice_distributions_all aid

2074:
2075: BEGIN
2076: --Bug#8240910 Reverted changes done on UPDATES to handle other exceptions reported
2077: -- by SLA as they are not swept now.
2078: UPDATE ap_invoice_distributions_all aid
2079: SET accounting_date = g_sweep_to_date,
2080: period_name = g_sweep_to_period,
2081: last_update_date = sysdate,
2082: last_updated_by = 5

Line 2090: debug ('update_ap_acct_date: total records updated in ap_invoice_distributions_all: '||sql%rowcount);

2086: AND gt.source_table_name = G_SRC_TAB_AP_INV_DISTS_ALL)
2087: AND aid.posted_flag in ('N','S','P') --Bug 9045217
2088: returning invoice_distribution_id bulk collect into l_dbi_key_value_list;
2089:
2090: debug ('update_ap_acct_date: total records updated in ap_invoice_distributions_all: '||sql%rowcount);
2091:
2092: forall i in l_dbi_key_value_list.first .. l_dbi_key_value_list.last
2093: update /*+index (gt AP_PERIOD_CLOSE_EXCPS_GT_N3)*/ ap_period_close_excps_gt gt --Bug 9045217
2094: set process_status_flag = 'Y'