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.INV_MGD_MVT_FIN_MDTR dependencies on AP_INVOICE_LINES_ALL

Line 724: , AP_INVOICE_LINES_ALL aila

720: SELECT
721: SUM(NVL(aila.amount,rctla.extended_amount))
722: FROM
723: AP_INVOICES_ALL aia
724: , AP_INVOICE_LINES_ALL aila
725: , RA_CUSTOMER_TRX_LINES_ALL rctla
726: , ra_customer_trx_all rcta
727: , oe_order_lines_all oola
728: WHERE aia.invoice_id = aila.invoice_id

Line 1144: AP_INVOICE_LINES_ALL aila

1140: SUM(aila.amount)
1141: , SUM(aila.quantity_invoiced)
1142: FROM
1143: AP_INVOICES_ALL aia,
1144: AP_INVOICE_LINES_ALL aila
1145: WHERE aia.invoice_id = aila.invoice_id
1146: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
1147: AND aila.rcv_transaction_id = l_parent_transaction_id
1148: AND aila.line_type_lookup_code = 'ITEM'

Line 1193: , AP_INVOICE_LINES_ALL aila

1189: FROM
1190: PO_HEADERS_ALL pha
1191: , PO_DISTRIBUTIONS_ALL pda
1192: , AP_INVOICES_ALL aia
1193: , AP_INVOICE_LINES_ALL aila
1194: WHERE pha.po_header_id = pda.po_header_id
1195: AND aia.invoice_id = aila.invoice_id
1196: AND pda.po_header_id = aila.po_header_id /*Bug 7446311 Joined to imporve performance*/
1197: AND pda.po_distribution_id = aila.po_distribution_id

Line 2413: , AP_INVOICE_LINES_ALL aila

2409: , SUM(NVL(aila.amount, 0))
2410: , SUM(NVL(aila.quantity_invoiced,0))
2411: FROM
2412: AP_INVOICES_ALL aia
2413: , AP_INVOICE_LINES_ALL aila
2414: , RA_CUSTOMER_TRX_LINES_ALL rctla
2415: , ra_customer_trx_all rcta
2416: WHERE aia.invoice_id = aila.invoice_id
2417: AND aia.cancelled_date IS NULL

Line 2447: , AP_INVOICE_LINES_ALL aila

2443: , NVL(aila.amount, 0)
2444: , NVL(aila.quantity_invoiced,0)
2445: FROM
2446: AP_INVOICES_ALL aia
2447: , AP_INVOICE_LINES_ALL aila
2448: , RA_CUSTOMER_TRX_LINES_ALL rctla
2449: , ra_customer_trx_all rcta
2450: , rcv_transactions rcv
2451: , rcv_shipment_lines rsl

Line 2489: , AP_INVOICE_LINES_ALL aila

2485: , NVL(aila.amount, 0)
2486: , NVL(aila.quantity_invoiced,0)
2487: FROM
2488: AP_INVOICES_ALL aia
2489: , AP_INVOICE_LINES_ALL aila
2490: , RA_CUSTOMER_TRX_LINES_ALL rctla
2491: , ra_customer_trx_all rcta
2492: , mtl_material_transactions mmt
2493: WHERE aia.invoice_id = aila.invoice_id

Line 2525: , AP_INVOICE_LINES_ALL aila

2521: , NVL(aila.amount, 0)
2522: , NVL(aila.quantity_invoiced,0)
2523: FROM
2524: AP_INVOICES_ALL aia
2525: , AP_INVOICE_LINES_ALL aila
2526: , RA_CUSTOMER_TRX_LINES_ALL rctla
2527: , ra_customer_trx_all rcta
2528: WHERE aia.invoice_id = aila.invoice_id
2529: AND aia.cancelled_date IS NULL

Line 2570: , AP_INVOICE_LINES_ALL aila

2566: , NVL(aila.amount, 0)
2567: , NVL(aila.quantity_invoiced,0)
2568: FROM
2569: AP_INVOICES_ALL aia
2570: , AP_INVOICE_LINES_ALL aila
2571: , RA_CUSTOMER_TRX_LINES_ALL rctla
2572: , ra_customer_trx_all rcta
2573: , mtl_material_transactions mmt
2574: WHERE aia.invoice_id = aila.invoice_id

Line 2773: , ap_invoice_lines_all aila

2769: , MAX(aia.invoice_id)
2770: , SUM(aila.quantity_invoiced)
2771: FROM
2772: ap_invoices_all aia
2773: , ap_invoice_lines_all aila
2774: WHERE aia.invoice_id = aila.invoice_id
2775: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2776: AND aia.cancelled_date IS NULL
2777: AND aila.line_type_lookup_code = 'ITEM'

Line 2845: , ap_invoice_lines_all aila

2841: SELECT
2842: SUM(aila.amount)
2843: FROM
2844: ap_invoices_all aia
2845: , ap_invoice_lines_all aila
2846: WHERE aia.invoice_id = aila.invoice_id
2847: AND aia.cancelled_date IS NULL
2848: AND aila.line_type_lookup_code = 'ITEM'
2849: AND aila.match_type = 'PRICE_CORRECTION'

Line 2875: , ap_invoice_lines_all aila

2871: SUM(aila.quantity_invoiced)
2872: , SUM(aila.amount)
2873: FROM
2874: ap_invoices_all aia
2875: , ap_invoice_lines_all aila
2876: WHERE aia.invoice_id = aila.invoice_id
2877: AND aia.cancelled_date IS NULL
2878: AND aila.line_type_lookup_code = 'ITEM'
2879: AND aila.match_type = 'QTY_CORRECTION'

Line 2909: , ap_invoice_lines_all aila

2905: , MAX(aia.invoice_id)
2906: , SUM(aila.quantity_invoiced)
2907: FROM
2908: ap_invoices_all aia
2909: , ap_invoice_lines_all aila
2910: WHERE aia.invoice_id = aila.invoice_id
2911: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
2912: AND aia.cancelled_date IS NULL
2913: AND aila.line_type_lookup_code = 'ITEM'

Line 2944: , ap_invoice_lines_all aila

2940: , MAX(aia.invoice_id)
2941: , sum(aila.quantity_invoiced)
2942: FROM
2943: ap_invoices_all aia
2944: , ap_invoice_lines_all aila
2945: WHERE aia.invoice_id = aila.invoice_id
2946: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2947: AND aia.cancelled_date IS NULL
2948: AND aila.line_type_lookup_code = 'ITEM'

Line 2980: , ap_invoice_lines_all aila

2976: SELECT
2977: SUM(aila.amount)
2978: FROM
2979: ap_invoices_all aia
2980: , ap_invoice_lines_all aila
2981: WHERE aia.invoice_id = aila.invoice_id
2982: AND aia.cancelled_date IS NULL
2983: AND aila.line_type_lookup_code = 'ITEM'
2984: AND aila.match_type = 'PRICE_CORRECTION'

Line 3011: , ap_invoice_lines_all aila

3007: SUM(aila.quantity_invoiced)
3008: , SUM(aila.amount)
3009: FROM
3010: ap_invoices_all aia
3011: , ap_invoice_lines_all aila
3012: WHERE aia.invoice_id = aila.invoice_id
3013: AND aia.cancelled_date IS NULL
3014: AND aila.line_type_lookup_code = 'ITEM'
3015: AND aila.match_type = 'QTY_CORRECTION'

Line 3045: , ap_invoice_lines_all aila

3041: , MAX(aia.invoice_id)
3042: , sum(aila.quantity_invoiced)
3043: FROM
3044: ap_invoices_all aia
3045: , ap_invoice_lines_all aila
3046: WHERE aia.invoice_id = aila.invoice_id
3047: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
3048: AND aia.cancelled_date IS NULL
3049: AND aila.line_type_lookup_code = 'ITEM'