552: FROM FII_AP_Invoice_B AI,
553: AP_Invoice_Distributions_All AID,
554: AP_Invoice_Lines_All AIL,
555: AP_Payment_Schedules_All PS,
556: FND_Currencies FC
557: WHERE AI.Invoice_ID = AID.Invoice_ID
558: AND AID.Invoice_ID = AIL.Invoice_ID
559: AND AID.Invoice_Line_Number = AIL.Line_Number
560: AND AI.Cancel_Date IS NULL
651: MIN(Check_ID) Check_ID
652: FROM AP_Invoice_Payments_All AIP1
653: GROUP BY Invoice_ID) AIP,
654: AP_Invoices_All AI,
655: FND_Currencies FC
656: WHERE AID.Invoice_ID = AI.Invoice_ID
657: AND AID.Invoice_ID = AIL.Invoice_ID
658: AND AID.Invoice_Line_Number = AIL.Line_Number
659: AND AID.Line_Type_Lookup_Code = 'PREPAY'
1048: Exchange_Rate,
1049: NVL(FC.Minimum_Accountable_Unit, 0.01) Functional_MAU
1050: FROM AP_Invoices_All AI,
1051: AP_System_Parameters_All ASP,
1052: FND_Currencies FC
1053: WHERE AI.Org_ID = ASP.Org_ID
1054: AND AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT'
1055: AND AI.Invoice_Amount <> 0
1056: AND TRUNC(AI.Creation_Date) >= g_start_date
2806: AP_Invoice_Lines_All AIL,
2807: AP_Payment_Schedules_All PS,
2808: FII_AP_PS_Rates_Temp RATES,
2809: FII_AP_Func_Rates_Temp FRATES,
2810: FND_Currencies FC
2811: WHERE PS.Invoice_ID = AI.Invoice_ID
2812: AND AID.Invoice_ID = AI.Invoice_ID
2813: AND AID.Invoice_ID = AIL.Invoice_ID
2814: AND AID.Invoice_Line_Number = AIL.Line_Number
3287: AP_Checks_All AC,
3288: -- IBY_Payment_Profiles IBYPM--IBY CHANGE
3289: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
3290: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B,--IBY CHANGE
3291: FND_Currencies FC
3292: WHERE AI.Invoice_ID BETWEEN g_start_range and g_end_range
3293: AND AI.Invoice_ID = TEMP.Invoice_ID
3294: AND TEMP.Invoice_ID = PS.Invoice_ID
3295: AND TEMP.Payment_Num = PS.Payment_Num