eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AP_INV_SUM_INIT dependencies on AP_INVOICE_PAYMENTS_ALL

Line 652: FROM AP_Invoice_Payments_All AIP1

648: AP_Invoice_Lines_All AIL,
649: AP_Invoice_Distributions_All TEMP,
650: (SELECT /*+ parallel(AIP1) */ Invoice_ID Invoice_ID,
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

Line 697: FROM AP_Invoice_Payments_All AIP,

693: (SELECT /*+ parallel(AI) parallel(AIP) parallel(PS) */
694: AIP.Invoice_ID Invoice_ID,
695: AIP.Payment_Num Payment_Num,
696: SUM(AIP.Amount + NVL(AIP.Discount_Taken, 0)) Payment_Amount
697: FROM AP_Invoice_Payments_All AIP,
698: FII_AP_Invoice_B AI,
699: AP_Payment_Schedules_All PS
700: WHERE PS.Invoice_ID = AI.Invoice_ID
701: AND AIP.Invoice_ID = AI.Invoice_ID

Line 796: AP_Invoice_Payments_All AIP,

792: TRUNC(AI.Entered_Date) Entered_Date,
793: TRUNC(AIP.Creation_Date) Invp_Creation_Date
794: FROM FII_AP_INVOICE_B AI,
795: AP_Checks_All AC,
796: AP_Invoice_Payments_All AIP,
797: AP_Payment_Schedules_All PS
798: WHERE AI.Invoice_ID = PS.Invoice_ID
799: AND PS.Invoice_ID = AIP.Invoice_ID
800: AND PS.Payment_Num = AIP.Payment_Num

Line 1443: FROM AP_Invoice_Payments_All AIP

1439: (SELECT /*+ no_merge parallel(AIP) */
1440: AIP.Invoice_id Invoice_ID,
1441: TRUNC(MAX(AIP.Creation_Date)) Fully_Paid_Date,
1442: SUM(AIP.Amount + NVL(AIP.Discount_Taken,0)) Fully_Paid_Amount_IP
1443: FROM AP_Invoice_Payments_All AIP
1444: GROUP BY AIP.Invoice_ID ) AIP,
1445: FII_AP_PS_Rates_Temp RATES,
1446: FII_AP_Func_Rates_Temp FRATES
1447: WHERE IB.Invoice_ID = PS.Invoice_ID

Line 1840: FROM AP_Invoice_Payments_All AIP_WH,

1836: NVL(SUM(CASE WHEN TEMP.Creation_Date IS NOT NULL
1837: AND TEMP.Creation_Date <= TRUNC(AIP_WH.Creation_Date)
1838: THEN TEMP.WH_Tax_Amount ELSE 0 END),0) WH_Tax_Amount,
1839: AIP_WH.Invoice_Payment_ID
1840: FROM AP_Invoice_Payments_All AIP_WH,
1841: FII_AP_WH_Tax_T TEMP
1842: WHERE AIP_WH.Invoice_ID BETWEEN g_start_range and g_end_range
1843: AND AIP_WH.Invoice_ID = TEMP.Invoice_ID (+)
1844: AND AIP_WH.Payment_Num = TEMP.Payment_Num (+)

Line 2104: FROM AP_Invoice_Payments_All AIP_WH,

2100: NVL(SUM(CASE WHEN TEMP.Creation_Date IS NOT NULL
2101: AND TEMP.Creation_Date <= TRUNC(AIP_WH.Creation_Date)
2102: THEN TEMP.WH_Tax_Amount ELSE 0 END),0) WH_Tax_Amount,
2103: AIP_WH.Invoice_Payment_ID
2104: FROM AP_Invoice_Payments_All AIP_WH,
2105: FII_AP_WH_Tax_T TEMP
2106: WHERE AIP_WH.Invoice_ID BETWEEN g_start_range and g_end_range
2107: AND AIP_WH.Invoice_ID = TEMP.Invoice_ID (+)
2108: AND AIP_WH.Payment_Num = TEMP.Payment_Num (+)

Line 6396: FROM AP_Invoice_Payments_ALL AIP

6392: (SELECT /*+ parallel(aip) */ AIP.Invoice_ID,
6393: AIP.Payment_Num,
6394: sum(AIP.Amount + nvl(AIP.Discount_Taken, 0)) Payment_Amount,
6395: trunc(max(AIP.Creation_Date)) Payment_Date
6396: FROM AP_Invoice_Payments_ALL AIP
6397: GROUP BY AIP.Invoice_id, AIP.Payment_Num) PAY,
6398: (SELECT /*+ parallel(t) */ Invoice_ID,
6399: Payment_Num,
6400: sum(WH_Tax_Amount) WH_Tax_Amount