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 690: AP_INVOICES_ALL aia

686: CURSOR l_cto_amt_ap IS
687: SELECT
688: SUM(NVL(aila.amount,rctla.extended_amount))
689: FROM
690: AP_INVOICES_ALL aia
691: , AP_INVOICE_LINES_ALL aila
692: , RA_CUSTOMER_TRX_LINES_ALL rctla
693: , ra_customer_trx_all rcta
694: , oe_order_lines_all oola

Line 1093: -- AP_INVOICES_ALL api,

1089: ---SELECT
1090: -- SUM(apid.amount)
1091: --, SUM(apid.quantity_invoiced)
1092: --FROM
1093: -- AP_INVOICES_ALL api,
1094: -- AP_INVOICE_DISTRIBUTIONS_ALL apid
1095: --WHERE api.invoice_id = apid.invoice_id
1096: --AND api.invoice_type_lookup_code in ('CREDIT','DEBIT')
1097: --AND apid.rcv_transaction_id = l_parent_transaction_id

Line 1110: AP_INVOICES_ALL aia,

1106: SELECT
1107: SUM(aila.amount)
1108: , SUM(aila.quantity_invoiced)
1109: FROM
1110: AP_INVOICES_ALL aia,
1111: AP_INVOICE_LINES_ALL aila
1112: WHERE aia.invoice_id = aila.invoice_id
1113: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
1114: AND aila.rcv_transaction_id = l_parent_transaction_id

Line 1138: --, AP_INVOICES_ALL d

1134: --, SUM(quantity_invoiced)
1135: --FROM
1136: -- PO_HEADERS_ALL b
1137: --, PO_DISTRIBUTIONS_ALL c
1138: --, AP_INVOICES_ALL d
1139: --, AP_INVOICE_DISTRIBUTIONS_ALL a
1140: --WHERE b.po_header_id = c.po_header_id
1141: --AND d.invoice_id = a.invoice_id
1142: --AND c.po_distribution_id = a.po_distribution_id

Line 1159: , AP_INVOICES_ALL aia

1155: , SUM(aila.quantity_invoiced)
1156: FROM
1157: PO_HEADERS_ALL pha
1158: , PO_DISTRIBUTIONS_ALL pda
1159: , AP_INVOICES_ALL aia
1160: , AP_INVOICE_LINES_ALL aila
1161: WHERE pha.po_header_id = pda.po_header_id
1162: AND aia.invoice_id = aila.invoice_id
1163: AND pda.po_header_id = aila.po_header_id /*Bug 7446311 Joined to imporve performance*/

Line 1536: AP_INVOICES_ALL

1532: NVL(invoice_currency_code, -1)
1533: INTO
1534: l_invoice_currency
1535: FROM
1536: AP_INVOICES_ALL
1537: WHERE
1538: invoice_id = l_movement_transaction.invoice_id ;
1539:
1540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2195: -- AP_INVOICES_ALL aia

2191: --, MAX(distribution_line_number)
2192: --, SUM(NVL(aida.amount,rctla.extended_amount))
2193: --, SUM(NVL(aida.quantity_invoiced,rctla.quantity_invoiced))
2194: --FROM
2195: -- AP_INVOICES_ALL aia
2196: --, AP_INVOICE_DISTRIBUTIONS_ALL aida
2197: --, RA_CUSTOMER_TRX_LINES_ALL rctla
2198: --, ra_customer_trx_all rcta
2199: --WHERE aia.invoice_id = aida.invoice_id

Line 2219: AP_INVOICES_ALL aia

2215: , MAX(aila.line_number)
2216: , SUM(NVL(aila.amount, 0))
2217: , SUM(NVL(aila.quantity_invoiced,0))
2218: FROM
2219: AP_INVOICES_ALL aia
2220: , AP_INVOICE_LINES_ALL aila
2221: , RA_CUSTOMER_TRX_LINES_ALL rctla
2222: , ra_customer_trx_all rcta
2223: WHERE aia.invoice_id = aila.invoice_id

Line 2249: AP_INVOICES_ALL aia

2245: SELECT
2246: SUM(NVL(rctla.extended_amount,0)) InvoiceAmount
2247: ,SUM(NVL(rctla.quantity_invoiced,0)) InvoicedQuantity
2248: FROM
2249: AP_INVOICES_ALL aia
2250: , RA_CUSTOMER_TRX_LINES_ALL rctla
2251: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2252: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2253: AND rctla.sales_order = to_char(l_movement_transaction.order_number)

Line 2262: AP_INVOICES_ALL aia

2258: SELECT
2259: SUM(NVL(rctla.extended_amount,0)) InvoiceAmount
2260: , SUM(NVL(rctla.quantity_credited,l_movement_transaction.transaction_quantity)) InvoicedQuantity
2261: FROM
2262: AP_INVOICES_ALL aia
2263: , RA_CUSTOMER_TRX_LINES_ALL rctla
2264: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2265: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2266: AND rctla.interface_line_attribute1 = to_char(l_movement_transaction.order_number)

Line 2282: AP_INVOICES_ALL ap

2278: , NVL(ap.exchange_date,rctl.exchange_date)
2279: , ap.batch_id
2280: , ap.invoice_date
2281: FROM
2282: AP_INVOICES_ALL ap
2283: , RA_CUSTOMER_TRX_ALL rctl
2284: WHERE ap.invoice_id = x_movement_transaction.invoice_id
2285: AND ap.reference_1 = rctl.customer_trx_id;
2286:

Line 2318: AP_INVOICES_ALL ap

2314: , ap.exchange_date
2315: , ap.batch_id
2316: , ap.invoice_date
2317: FROM
2318: AP_INVOICES_ALL ap
2319: WHERE ap.invoice_id = x_movement_transaction.invoice_id;
2320:
2321: -- Cursor for PO based matching regular invoice
2322: -- modified for AP invoice lines uptake in R12

Line 2330: ap_invoices_all aia

2326: , MAX(aila.line_number)
2327: , MAX(aia.invoice_id)
2328: , SUM(aila.quantity_invoiced)
2329: FROM
2330: ap_invoices_all aia
2331: , ap_invoice_lines_all aila
2332: WHERE aia.invoice_id = aila.invoice_id
2333: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2334: AND aia.cancelled_date IS NULL

Line 2366: ap_invoices_all aia

2362: CURSOR l_po_prc_inv IS
2363: SELECT
2364: SUM(aila.amount)
2365: FROM
2366: ap_invoices_all aia
2367: , ap_invoice_lines_all aila
2368: WHERE aia.invoice_id = aila.invoice_id
2369: AND aia.cancelled_date IS NULL
2370: AND aila.line_type_lookup_code = 'ITEM'

Line 2396: ap_invoices_all aia

2392: SELECT
2393: SUM(aila.quantity_invoiced)
2394: , SUM(aila.amount)
2395: FROM
2396: ap_invoices_all aia
2397: , ap_invoice_lines_all aila
2398: WHERE aia.invoice_id = aila.invoice_id
2399: AND aia.cancelled_date IS NULL
2400: AND aila.line_type_lookup_code = 'ITEM'

Line 2430: ap_invoices_all aia

2426: , MAX(aila.line_number)
2427: , MAX(aia.invoice_id)
2428: , SUM(aila.quantity_invoiced)
2429: FROM
2430: ap_invoices_all aia
2431: , ap_invoice_lines_all aila
2432: WHERE aia.invoice_id = aila.invoice_id
2433: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
2434: AND aia.cancelled_date IS NULL

Line 2465: ap_invoices_all aia

2461: , MAX(aila.line_number)
2462: , MAX(aia.invoice_id)
2463: , sum(aila.quantity_invoiced)
2464: FROM
2465: ap_invoices_all aia
2466: , ap_invoice_lines_all aila
2467: WHERE aia.invoice_id = aila.invoice_id
2468: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2469: AND aia.cancelled_date IS NULL

Line 2501: ap_invoices_all aia

2497: CURSOR l_ap_prc_inv IS
2498: SELECT
2499: SUM(aila.amount)
2500: FROM
2501: ap_invoices_all aia
2502: , ap_invoice_lines_all aila
2503: WHERE aia.invoice_id = aila.invoice_id
2504: AND aia.cancelled_date IS NULL
2505: AND aila.line_type_lookup_code = 'ITEM'

Line 2532: ap_invoices_all aia

2528: SELECT
2529: SUM(aila.quantity_invoiced)
2530: , SUM(aila.amount)
2531: FROM
2532: ap_invoices_all aia
2533: , ap_invoice_lines_all aila
2534: WHERE aia.invoice_id = aila.invoice_id
2535: AND aia.cancelled_date IS NULL
2536: AND aila.line_type_lookup_code = 'ITEM'

Line 2566: ap_invoices_all aia

2562: , MAX(aila.line_number)
2563: , MAX(aia.invoice_id)
2564: , sum(aila.quantity_invoiced)
2565: FROM
2566: ap_invoices_all aia
2567: , ap_invoice_lines_all aila
2568: WHERE aia.invoice_id = aila.invoice_id
2569: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
2570: AND aia.cancelled_date IS NULL

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

3044: -- if Amount or Quantity is missing from AP Invoice.
3045:
3046: /* 7165989 - new cursor defined for intercompany RMA Dispatch */
3047: /* The invoice quantity is fetched from quantity_credited in RA_CUSTOMER_TRX_LINES_ALL*/
3048: /* as AP_INVOICES_ALL does not have the invoice quantity */
3049: IF l_extended_amount = 0 OR x_movement_transaction.invoice_quantity = 0 THEN
3050: OPEN l_ap_intercompany_rma_inv_qty;
3051: FETCH l_ap_intercompany_rma_inv_qty INTO
3052: l_ar_invoiced_amount, l_ar_invoiced_qty;