797: END) As ERV_Amount,
798: AI.Invoice_Currency_Code Invoice_Currency_Code,
799: AI.Set_Of_Books_ID Set_Of_Books_ID
800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
799: AI.Set_Of_Books_ID Set_Of_Books_ID
800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID
807: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID
807: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
808: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)
809: AND ACA.Item_Dist_ID = ACA1.Charge_Dist_ID (+)
2235: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2236: AID.Set_Of_Books_ID
2237: FROM AP_Invoices_All AI,
2238: AP_Dist_Line_GT AID,
2239: AP_Chrg_Allocations_All ACA,
2240: AP_Inv_Dists_Source AID1
2241: WHERE AI.Invoice_ID = AID.Invoice_ID
2242: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID
2243: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID