DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_LINE_TEMP_GT

Line 1811: AP_Line_Temp_GT Line

1807: 'N' RCV_Charge_Addition_Flag
1808: FROM AP_Invoices_ALL AI,
1809: AP_Dist_Line_GT AID,
1810: AP_Tax_Alloc_Amount_GT ACA,
1811: AP_Line_Temp_GT Line
1812: WHERE AI.Invoice_ID = AID.Invoice_ID
1813: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1814: 'IPI', 'FREIGHT', 'MISCELLANEOUS')
1815: AND AID.Invoice_Distribution_ID = ACA.Old_Dist_ID (+)

Line 2249: AP_Line_Temp_GT Line

2245: AID.Base_Amount,
2246: AID.Tax_Recovery_Rate,
2247: AID.Set_Of_Books_ID
2248: ) ALLOC,
2249: AP_Line_Temp_GT Line
2250: WHERE AI.Invoice_ID = AID.Invoice_ID
2251: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
2252: AND AI.Invoice_Currency_Code = FC.Currency_Code
2253: AND AID.Line_Type_Lookup_Code = 'TAX'

Line 2313: INSERT INTO AP_Line_Temp_GT (Line_Type)

2309:
2310: Delete_Lines_Dists(l_curr_calling_sequence);
2311:
2312: FORALL i IN linetype.FIRST..linetype.LAST
2313: INSERT INTO AP_Line_Temp_GT (Line_Type)
2314: VALUES (linetype(i));
2315:
2316: l_debug_info := 'Calling procedure insert_dist_line_info';
2317: IF g_debug_flag = 'Y' THEN