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_INVOICES_ALL

Line 723: AP_INVOICES_ALL aia

719: CURSOR l_cto_amt_ap IS
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

Line 1126: -- AP_INVOICES_ALL api,

1122: ---SELECT
1123: -- SUM(apid.amount)
1124: --, SUM(apid.quantity_invoiced)
1125: --FROM
1126: -- AP_INVOICES_ALL api,
1127: -- AP_INVOICE_DISTRIBUTIONS_ALL apid
1128: --WHERE api.invoice_id = apid.invoice_id
1129: --AND api.invoice_type_lookup_code in ('CREDIT','DEBIT')
1130: --AND apid.rcv_transaction_id = l_parent_transaction_id

Line 1143: AP_INVOICES_ALL aia,

1139: SELECT
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

Line 1171: --, AP_INVOICES_ALL d

1167: --, SUM(quantity_invoiced)
1168: --FROM
1169: -- PO_HEADERS_ALL b
1170: --, PO_DISTRIBUTIONS_ALL c
1171: --, AP_INVOICES_ALL d
1172: --, AP_INVOICE_DISTRIBUTIONS_ALL a
1173: --WHERE b.po_header_id = c.po_header_id
1174: --AND d.invoice_id = a.invoice_id
1175: --AND c.po_distribution_id = a.po_distribution_id

Line 1192: , AP_INVOICES_ALL aia

1188: , SUM(aila.quantity_invoiced)
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*/

Line 1580: AP_INVOICES_ALL

1576: NVL(invoice_currency_code, -1)
1577: INTO
1578: l_invoice_currency
1579: FROM
1580: AP_INVOICES_ALL
1581: WHERE
1582: invoice_id = l_movement_transaction.invoice_id ;
1583:
1584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2386: -- AP_INVOICES_ALL aia

2382: --, MAX(distribution_line_number)
2383: --, SUM(NVL(aida.amount,rctla.extended_amount))
2384: --, SUM(NVL(aida.quantity_invoiced,rctla.quantity_invoiced))
2385: --FROM
2386: -- AP_INVOICES_ALL aia
2387: --, AP_INVOICE_DISTRIBUTIONS_ALL aida
2388: --, RA_CUSTOMER_TRX_LINES_ALL rctla
2389: --, ra_customer_trx_all rcta
2390: --WHERE aia.invoice_id = aida.invoice_id

Line 2412: AP_INVOICES_ALL aia

2408: , MAX(aila.line_number)
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

Line 2446: AP_INVOICES_ALL aia

2442: , aila.line_number
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

Line 2488: AP_INVOICES_ALL aia

2484: , aila.line_number
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

Line 2524: AP_INVOICES_ALL aia

2520: , aila.line_number
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

Line 2569: AP_INVOICES_ALL aia

2565: , aila.line_number
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

Line 2603: AP_INVOICES_ALL aia

2599: SELECT
2600: SUM(NVL(rctla.extended_amount,0)) InvoiceAmount
2601: ,SUM(NVL(rctla.quantity_invoiced,0)) InvoicedQuantity
2602: FROM
2603: AP_INVOICES_ALL aia
2604: , RA_CUSTOMER_TRX_LINES_ALL rctla
2605: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2606: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2607: AND rctla.sales_order = to_char(l_movement_transaction.order_number)

Line 2618: AP_INVOICES_ALL aia

2614: SELECT
2615: NVL(rctla.extended_amount,0) InvoiceAmount
2616: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2617: FROM
2618: AP_INVOICES_ALL aia
2619: , RA_CUSTOMER_TRX_LINES_ALL rctla
2620: , rcv_transactions rcv
2621: , rcv_shipment_lines rsl
2622: , mtl_material_transactions mmt

Line 2640: AP_INVOICES_ALL aia

2636: SELECT
2637: NVL(rctla.extended_amount,0) InvoiceAmount
2638: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2639: FROM
2640: AP_INVOICES_ALL aia
2641: , RA_CUSTOMER_TRX_LINES_ALL rctla
2642: , mtl_material_transactions mmt
2643: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2644: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2657: AP_INVOICES_ALL aia

2653: SELECT
2654: NVL(rctla.extended_amount,0) InvoiceAmount
2655: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2656: FROM
2657: AP_INVOICES_ALL aia
2658: , RA_CUSTOMER_TRX_LINES_ALL rctla
2659: , mtl_material_transactions mmt
2660: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2661: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2674: AP_INVOICES_ALL aia

2670: SELECT
2671: NVL(rctla.extended_amount,0) InvoiceAmount
2672: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2673: FROM
2674: AP_INVOICES_ALL aia
2675: , RA_CUSTOMER_TRX_LINES_ALL rctla
2676: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2677: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2678: AND rctla.sales_order = to_char(l_movement_transaction.order_number)

Line 2704: AP_INVOICES_ALL aia

2700: SELECT
2701: SUM(NVL(rctla.extended_amount,0)) InvoiceAmount
2702: , SUM(NVL(rctla.quantity_credited,l_movement_transaction.transaction_quantity)) InvoicedQuantity
2703: FROM
2704: AP_INVOICES_ALL aia
2705: , RA_CUSTOMER_TRX_LINES_ALL rctla
2706: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2707: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2708: AND rctla.interface_line_attribute1 = to_char(l_movement_transaction.order_number)

Line 2724: AP_INVOICES_ALL ap

2720: , NVL(ap.exchange_date,rctl.exchange_date)
2721: , ap.batch_id
2722: , ap.invoice_date
2723: FROM
2724: AP_INVOICES_ALL ap
2725: , RA_CUSTOMER_TRX_ALL rctl
2726: WHERE ap.invoice_id = x_movement_transaction.invoice_id
2727: AND ap.reference_1 = rctl.customer_trx_id;
2728:

Line 2760: AP_INVOICES_ALL ap

2756: , ap.exchange_date
2757: , ap.batch_id
2758: , ap.invoice_date
2759: FROM
2760: AP_INVOICES_ALL ap
2761: WHERE ap.invoice_id = x_movement_transaction.invoice_id;
2762:
2763: -- Cursor for PO based matching regular invoice
2764: -- modified for AP invoice lines uptake in R12

Line 2772: ap_invoices_all aia

2768: , MAX(aila.line_number)
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

Line 2806: AP_INVOICES_ALL b

2802: CURSOR l_po_line_number IS
2803: SELECT
2804: MAX(distribution_line_number)
2805: FROM
2806: AP_INVOICES_ALL b
2807: , AP_INVOICE_DISTRIBUTIONS_ALL a
2808: WHERE b.invoice_id = x_movement_transaction.invoice_id
2809: AND b.invoice_id = a.invoice_id
2810: AND (NVL(a.match_status_flag,'N') = 'A'

Line 2820: AP_INVOICES_ALL b

2816: CURSOR l_po_line_number IS
2817: SELECT
2818: MAX(distribution_line_number)
2819: FROM
2820: AP_INVOICES_ALL b
2821: , AP_INVOICE_DISTRIBUTIONS_ALL a
2822: , PO_DISTRIBUTIONS_ALL c
2823: WHERE b.invoice_id = x_movement_transaction.invoice_id
2824: AND b.invoice_id = a.invoice_id

Line 2844: ap_invoices_all aia

2840: CURSOR l_po_prc_inv IS
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'

Line 2874: ap_invoices_all aia

2870: SELECT
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'

Line 2908: ap_invoices_all aia

2904: , MAX(aila.line_number)
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

Line 2943: ap_invoices_all aia

2939: , MAX(aila.line_number)
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

Line 2979: ap_invoices_all aia

2975: CURSOR l_ap_prc_inv IS
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'

Line 3010: ap_invoices_all aia

3006: SELECT
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'

Line 3044: ap_invoices_all aia

3040: , MAX(aila.line_number)
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

Line 3715: /* as AP_INVOICES_ALL does not have the invoice quantity */

3711: -- if Amount or Quantity is missing from AP Invoice.
3712:
3713: /* 7165989 - new cursor defined for intercompany RMA Dispatch */
3714: /* The invoice quantity is fetched from quantity_credited in RA_CUSTOMER_TRX_LINES_ALL*/
3715: /* as AP_INVOICES_ALL does not have the invoice quantity */
3716: IF l_extended_amount = 0 OR x_movement_transaction.invoice_quantity = 0 THEN
3717:
3718: OPEN l_ap_intercompany_rma_inv_qty;
3719: FETCH l_ap_intercompany_rma_inv_qty INTO