[Home] [Help]
584: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
585: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.Nextval)),
586: ZX_Lines_Summary_S.Nextval),
587: NULL) Summary_Tax_Line_ID
588: FROM AP_Invoices_ALL AI,
589: AP_Inv_Dists_Source AID,
590: AP_Inv_Dists_Source AID1,
591: ZX_Rates_B ZXR
592: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
817: / DECODE(AID.Base_Amount, 0, 1, AID.Base_Amount)
818: END) As ERV_Amount,
819: AI.Invoice_Currency_Code Invoice_Currency_Code,
820: AI.Set_Of_Books_ID Set_Of_Books_ID
821: FROM AP_Invoices_All AI,
822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
1361: ZXR.Percentage_Rate, NULL) Tax_Rate,
1362: ZXR.Tax_Rate_ID Tax_Code_ID,
1363: 'Y'
1364: FROM AP_System_Parameters_All ASP,
1365: AP_Invoices_All AI,
1366: AP_Dist_Line_GT AID,
1367: PO_Distributions_All PD,
1368: PO_Lines_All PL,
1369: AP_Inv_Dists_Source AID1,
1804: AI.global_attribute10
1805: END) AS Intended_Use,
1806: 'Y' Historical_Flag,
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
2218: END) AS Intended_Use,
2219: 'Y' Historical_Flag,
2220: 'N' RCV_Charge_Addition_Flag
2221: FROM AP_System_Parameters_All ASP,
2222: AP_Invoices_ALL AI,
2223: FND_Currencies FC,
2224: AP_Dist_Line_GT AID,
2225: AP_Tax_Alloc_Amount_GT TAA,
2226: AP_Tax_Alloc_Amount_GT TAA1,
2231: SUM(NVL(ACA.Allocated_Amount,AID.Amount)) Sum_Alloc_Amount,
2232: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
2233: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2234: AID.Set_Of_Books_ID
2235: FROM AP_Invoices_All AI,
2236: AP_Dist_Line_GT AID,
2237: AP_Chrg_Allocations_All ACA,
2238: AP_Inv_Dists_Source AID1
2239: WHERE AI.Invoice_ID = AID.Invoice_ID