[Home] [Help]
665: --
666: l_curr_calling_sequence := 'Insert_Alloc_Info <-'||P_calling_sequence;
667: --
668:
669: l_debug_info := 'Inserting into AP_TAX_ALLOC_AMOUNT_GT table';
670: IF g_debug_flag = 'Y' THEN
671: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
672: END IF;
673:
674:
675: /* Inserting into temp table the distribution amount that
676: will be calculated for a tax line */
677:
678: INSERT INTO AP_Tax_Alloc_Amount_GT t1
679: (Invoice_ID,
680: Line_Number,
681: Line_Amount,
682: Line_Base_Amount,
1881: 'Y' Historical_Flag,
1882: 'N' RCV_Charge_Addition_Flag
1883: FROM AP_Invoices_ALL AI,
1884: AP_Dist_Line_GT AID,
1885: AP_Tax_Alloc_Amount_GT ACA,
1886: AP_Line_Temp_GT Line
1887: WHERE AI.Invoice_ID = AID.Invoice_ID
1888: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1889: 'IPI', 'FREIGHT', 'MISCELLANEOUS')
2306: FROM AP_System_Parameters_All ASP,
2307: AP_Invoices_ALL AI,
2308: FND_Currencies FC,
2309: AP_Dist_Line_GT AID,
2310: AP_Tax_Alloc_Amount_GT TAA,
2311: AP_Tax_Alloc_Amount_GT TAA1,
2312: AP_Dist_Line_GT AID1,
2313: (SELECT /*+ ROWID (AI) Ordered USE_NL(ACA,AID,AID1) */
2314: AID.Invoice_Distribution_ID Item_Dist_ID,
2307: AP_Invoices_ALL AI,
2308: FND_Currencies FC,
2309: AP_Dist_Line_GT AID,
2310: AP_Tax_Alloc_Amount_GT TAA,
2311: AP_Tax_Alloc_Amount_GT TAA1,
2312: AP_Dist_Line_GT AID1,
2313: (SELECT /*+ ROWID (AI) Ordered USE_NL(ACA,AID,AID1) */
2314: AID.Invoice_Distribution_ID Item_Dist_ID,
2315: AID.Amount Item_Amount,
2354: Made AP_INVOICE_DISTRIBUTIONS_N25 as a non-deferred hint in apsin.odf */
2355: UPDATE /*+ bypass_ujvc */
2356: (SELECT /*+ leading(p,aid,r) use_nl(aid,r) index(aid,AP_INVOICE_DISTRIBUTIONS_N25) */ p.new_dist_id,
2357: aid.parent_reversal_id
2358: FROM ap_tax_alloc_amount_gt p,
2359: ap_inv_dists_target r,
2360: ap_inv_dists_target aid
2361: WHERE r.invoice_distribution_id = aid.charge_applicable_to_dist_id
2362: AND p.item_dist_id = nvl(r.parent_reversal_id, aid.charge_applicable_to_dist_id)