APPS.AP_LINES_UPGRADE_PKG dependencies on AP_TAX_ALLOC_AMOUNT_GT

Line 725: l_debug_info := 'Inserting into AP_TAX_ALLOC_AMOUNT_GT table';

721: --
722: l_curr_calling_sequence := 'Insert_Alloc_Info <-'||P_calling_sequence;
723: --
724:
725: l_debug_info := 'Inserting into AP_TAX_ALLOC_AMOUNT_GT table';
726: IF g_debug_flag = 'Y' THEN
727: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
728: END IF;
729:

Line 734: INSERT INTO AP_Tax_Alloc_Amount_GT t1

730:
731: /* Inserting into temp table the distribution amount that
732: will be calculated for a tax line */
733:
734: INSERT INTO AP_Tax_Alloc_Amount_GT t1
735: (Invoice_ID,
736: Line_Number,
737: Line_Amount,
738: Line_Base_Amount,

Line 1986: AP_Tax_Alloc_Amount_GT ACA,

1982: aid.INVOICE_INCLUDES_PREPAY_FLAG, --13774403 populating the flag for upgraded transactions
1983: 'N' RCV_Charge_Addition_Flag
1984: FROM AP_Invoices_ALL AI,
1985: AP_Dist_Line_GT AID,
1986: AP_Tax_Alloc_Amount_GT ACA,
1987: AP_Line_Temp_GT Line,
1988: PO_Distributions_All POD --13444893
1989: WHERE AI.Invoice_ID = AID.Invoice_ID
1990: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',

Line 2396: AP_Tax_Alloc_Amount_GT TAA,

2392: FROM AP_System_Parameters_All ASP,
2393: AP_Invoices_ALL AI,
2394: FND_Currencies FC,
2395: AP_Dist_Line_GT AID,
2396: AP_Tax_Alloc_Amount_GT TAA,
2397: AP_Tax_Alloc_Amount_GT TAA1,
2398: AP_Dist_Line_GT AID1,
2399: (SELECT /*+ cardinality(AI,1) rowid(AI) USE_NL(AI, AID, ACA, AID1)
2400: index(aid AP_INVOICE_DISTS_ARCH_U1) index(aid1 ap_invoice_dists_arch_u2)*/ -- Bug 13837821/16025353 Hint modified for perf

Line 2397: AP_Tax_Alloc_Amount_GT TAA1,

2393: AP_Invoices_ALL AI,
2394: FND_Currencies FC,
2395: AP_Dist_Line_GT AID,
2396: AP_Tax_Alloc_Amount_GT TAA,
2397: AP_Tax_Alloc_Amount_GT TAA1,
2398: AP_Dist_Line_GT AID1,
2399: (SELECT /*+ cardinality(AI,1) rowid(AI) USE_NL(AI, AID, ACA, AID1)
2400: index(aid AP_INVOICE_DISTS_ARCH_U1) index(aid1 ap_invoice_dists_arch_u2)*/ -- Bug 13837821/16025353 Hint modified for perf
2401: AID.Invoice_Distribution_ID Item_Dist_ID,

Line 2424: AP_Tax_Alloc_Amount_GT TAA2 --8608129

2420: AID.Tax_Recovery_Rate,
2421: AID.Set_Of_Books_ID
2422: ) ALLOC,
2423: AP_Line_Temp_GT Line,
2424: AP_Tax_Alloc_Amount_GT TAA2 --8608129
2425: WHERE AI.Invoice_ID = AID.Invoice_ID
2426: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
2427: AND AI.Invoice_Currency_Code = FC.Currency_Code
2428: AND AID.Line_Type_Lookup_Code = 'TAX'