[Home] [Help]
186: ,G_SRC_TYP_UNACCT_DISTS
187: ,G_SRC_TAB_AP_INV_DISTS_ALL
188: from
189: ap_invoices_all ai
190: ,ap_invoice_distributions_all aid
191: ,ap_org_attributes_gt org_gtt
192: where
193: ai.invoice_id = aid.invoice_id
194: -- bug 7311486 UTR report must run even if dates and period is not specified
252: ,G_SRC_TYP_UNACCT_DISTS
253: ,G_SRC_TAB_AP_INV_DISTS_ALL
254: from
255: ap_invoices_all ai
256: ,ap_invoice_distributions_all aid
257: ,ap_org_attributes_gt org_gtt
258: where
259: ai.invoice_id = aid.invoice_id
260: -- bug 7311486 UTR report must run even if dates and period is not specified
455: and (ail.accounting_date between g_period_start_date and g_period_end_date)
456:
457: --and ail.accounting_date between g_period_start_date and g_period_end_date
458: and not exists (select 1 --> lines without distributions
459: from ap_invoice_distributions_all aid
460: where aid.invoice_id = ai.invoice_id
461: and aid.invoice_line_number = ail.line_number
462:
463: --Bug 7242216 Excluding invoices having discarded lines with
517: -- and (ail.accounting_date between g_period_start_date and g_period_end_date)
518:
519: --and ail.accounting_date between g_period_start_date and g_period_end_date
520: and not exists (select 1 --> lines without distributions
521: from ap_invoice_distributions_all aid
522: where aid.invoice_id = ai.invoice_id
523: and aid.invoice_line_number = ail.line_number
524:
525: --Bug 7242216 Excluding invoices having discarded lines with
832: g_period_start_date IS NULL AND
833: g_period_end_date IS NULL))
834: AND NOT EXISTS
835: (SELECT 1
836: FROM ap_invoice_distributions_all aid
837: WHERE aid.accounting_event_id = xe.event_id)
838: AND NOT EXISTS
839: (SELECT 1
840: FROM ap_invoice_distributions_all aid
836: FROM ap_invoice_distributions_all aid
837: WHERE aid.accounting_event_id = xe.event_id)
838: AND NOT EXISTS
839: (SELECT 1
840: FROM ap_invoice_distributions_all aid
841: WHERE aid.bc_event_id = xe.event_id)
842: AND NOT EXISTS
843: (SELECT 1
844: FROM ap_self_assessed_tax_dist_all aid
1370:
1371: if p_context = 'INV' then
1372: /* select count(*) --commented this peice of code 7318763
1373: into l_count
1374: from ap_invoice_distributions_all
1375: where accounting_event_id = p_event_id
1376: and invoice_id = p_trans_id
1377: and awt_invoice_payment_id is not null; */
1378:
1793: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1794:
1795: BEGIN
1796:
1797: UPDATE ap_invoice_distributions_all aid
1798: SET accounting_date = g_sweep_to_date,
1799: period_name = g_sweep_to_period,
1800: last_update_date = sysdate,
1801: last_updated_by = 5
1805: AND gt.source_table_name = G_SRC_TAB_AP_INV_DISTS_ALL)
1806: AND aid.posted_flag <> 'Y'
1807: returning invoice_distribution_id bulk collect into l_dbi_key_value_list;
1808:
1809: debug ('update_ap_acct_date: total records updated in ap_invoice_distributions_all: '||sql%rowcount);
1810:
1811: forall i in l_dbi_key_value_list.first .. l_dbi_key_value_list.last
1812: update ap_period_close_excps_gt gt
1813: set process_status_flag = 'Y'
2028: AND xe.event_date BETWEEN g_period_start_date
2029: AND g_period_end_date
2030: AND NOT EXISTS
2031: (SELECT 1
2032: FROM ap_invoice_distributions_all aid
2033: WHERE aid.accounting_event_id = xe.event_id)
2034: AND NOT EXISTS
2035: (SELECT 1
2036: FROM ap_invoice_distributions_all aid
2032: FROM ap_invoice_distributions_all aid
2033: WHERE aid.accounting_event_id = xe.event_id)
2034: AND NOT EXISTS
2035: (SELECT 1
2036: FROM ap_invoice_distributions_all aid
2037: WHERE aid.bc_event_id = xe.event_id)
2038: AND NOT EXISTS
2039: (SELECT 1
2040: FROM ap_self_assessed_tax_dist_all aid