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 RA_CUSTOMER_TRX_ALL

Line 332: RA_CUSTOMER_TRX_ALL rat

328: CURSOR l_cto_amt IS
329: SELECT
330: SUM(ratl.extended_amount)
331: FROM
332: RA_CUSTOMER_TRX_ALL rat
333: , RA_CUSTOMER_TRX_LINES_ALL ratl
334: , RA_CUST_TRX_TYPES_ALL ratt
335: , oe_order_lines_all oola
336: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 359: RA_CUSTOMER_TRX_ALL rat

355: CURSOR l_cto_cm_amt IS
356: SELECT
357: SUM(ratl.extended_amount)
358: FROM
359: RA_CUSTOMER_TRX_ALL rat
360: , RA_CUSTOMER_TRX_LINES_ALL ratl
361: , RA_CUST_TRX_TYPES_ALL ratt
362: , oe_order_lines_all oola
363: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 441: RA_CUSTOMER_TRX_ALL rat

437: CURSOR l_cto_amt_drp IS
438: SELECT
439: SUM(ratl.extended_amount)
440: FROM
441: RA_CUSTOMER_TRX_ALL rat
442: , RA_CUSTOMER_TRX_LINES_ALL ratl
443: , RA_CUST_TRX_TYPES_ALL ratt --add in for fixing bug 2447381
444: , oe_order_lines_all oola
445: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 469: RA_CUSTOMER_TRX_ALL rat

465: CURSOR l_cto_cm_amt_drp IS
466: SELECT
467: SUM(ratl.extended_amount)
468: FROM
469: RA_CUSTOMER_TRX_ALL rat
470: , RA_CUSTOMER_TRX_LINES_ALL ratl
471: , RA_CUST_TRX_TYPES_ALL ratt
472: , oe_order_lines_all oola
473: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 554: RA_CUSTOMER_TRX_ALL rat

550: /*CURSOR l_cto_amt_rma IS
551: SELECT
552: SUM(ratl.extended_amount)
553: FROM
554: RA_CUSTOMER_TRX_ALL rat
555: , RA_CUSTOMER_TRX_LINES_ALL ratl
556: , RA_CUST_TRX_TYPES_ALL ratt
557: , oe_order_lines_all oola
558: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 580: RA_CUSTOMER_TRX_ALL rat

576: CURSOR l_cto_amt_rma IS
577: SELECT
578: SUM(ratl.extended_amount)
579: FROM
580: RA_CUSTOMER_TRX_ALL rat
581: , RA_CUSTOMER_TRX_LINES_ALL ratl
582: , RA_CUST_TRX_TYPES_ALL ratt
583: WHERE rat.customer_trx_id = ratl.customer_trx_id
584: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 726: , ra_customer_trx_all rcta

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
729: AND aia.cancelled_date IS NULL
730: AND aila.line_type_lookup_code = 'ITEM'

Line 908: RA_CUSTOMER_TRX_ALL rat

904: CURSOR c_invoiced_line_qty IS
905: SELECT
906: SUM(NVL(ratl.quantity_invoiced,0))
907: FROM
908: RA_CUSTOMER_TRX_ALL rat
909: , RA_CUSTOMER_TRX_LINES_ALL ratl
910: , RA_CUST_TRX_TYPES_ALL ratt
911: WHERE rat.customer_trx_id = ratl.customer_trx_id
912: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 1049: RA_CUSTOMER_TRX_ALL rat

1045: SELECT
1046: SUM(NVL(ratl.extended_amount,0))
1047: , SUM(NVL(ratl.quantity_credited,0))
1048: FROM
1049: RA_CUSTOMER_TRX_ALL rat
1050: , RA_CUSTOMER_TRX_LINES_ALL ratl
1051: , RA_CUST_TRX_TYPES_ALL ratt
1052: , OE_ORDER_LINES_ALL oola
1053: , RCV_TRANSACTIONS rt

Line 2137: RA_CUSTOMER_TRX_ALL rat

2133: , rat.exchange_rate_type
2134: , rat.exchange_date
2135: , NVL(rat.invoice_currency_code,l_movement_transaction.currency_code)
2136: FROM
2137: RA_CUSTOMER_TRX_ALL rat
2138: WHERE rat.customer_trx_id = x_movement_transaction.invoice_id;
2139:
2140: -- Cursor for SO invoices which are non credit/debit memos.
2141:

Line 2149: RA_CUSTOMER_TRX_ALL rat

2145: , MAX(rat.customer_trx_id)
2146: , SUM(ratl.extended_amount)
2147: , SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2148: FROM
2149: RA_CUSTOMER_TRX_ALL rat
2150: , RA_CUSTOMER_TRX_LINES_ALL ratl
2151: , RA_CUST_TRX_TYPES_ALL ratt
2152: WHERE rat.customer_trx_id = ratl.customer_trx_id
2153: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2178: RA_CUSTOMER_TRX_ALL rat

2174: , MAX(rat.customer_trx_id)
2175: , SUM(ratl.extended_amount)
2176: , SUM(NVL(ratl.quantity_credited,l_movement_transaction.transaction_quantity))
2177: FROM
2178: RA_CUSTOMER_TRX_ALL rat
2179: , RA_CUSTOMER_TRX_LINES_ALL ratl
2180: , RA_CUST_TRX_TYPES_ALL ratt
2181: WHERE rat.customer_trx_id = ratl.customer_trx_id
2182: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2201: RA_CUSTOMER_TRX_ALL rat

2197: CURSOR l_sum_cm_arc IS
2198: SELECT
2199: SUM(ratl.extended_amount)
2200: FROM
2201: RA_CUSTOMER_TRX_ALL rat
2202: , RA_CUSTOMER_TRX_LINES_ALL ratl
2203: , RA_CUST_TRX_TYPES_ALL ratt
2204: WHERE rat.customer_trx_id = ratl.customer_trx_id
2205: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2251: RA_CUSTOMER_TRX_ALL rat

2247: , MAX(rat.customer_trx_id)
2248: , SUM(ratl.extended_amount)
2249: , SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2250: FROM
2251: RA_CUSTOMER_TRX_ALL rat
2252: , RA_CUSTOMER_TRX_LINES_ALL ratl
2253: , RA_CUST_TRX_TYPES_ALL ratt --add in for fixing bug 2447381
2254: WHERE rat.customer_trx_id = ratl.customer_trx_id
2255: --AND ratl.quantity_invoiced = ratl.quantity_ordered

Line 2279: RA_CUSTOMER_TRX_ALL rat

2275: CURSOR l_sum_cm_drparc IS
2276: SELECT
2277: SUM(ratl.extended_amount)
2278: FROM
2279: RA_CUSTOMER_TRX_ALL rat
2280: , RA_CUSTOMER_TRX_LINES_ALL ratl
2281: , RA_CUST_TRX_TYPES_ALL ratt
2282: WHERE rat.customer_trx_id = ratl.customer_trx_id
2283: --AND ratl.quantity_invoiced = ratl.quantity_ordered

Line 2316: RA_CUSTOMER_TRX_ALL rat

2312: , SUM(ratl.extended_amount)
2313: --, SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2314: , SUM(NVL(ratl.quantity_credited,l_movement_transaction.transaction_quantity))
2315: FROM
2316: RA_CUSTOMER_TRX_ALL rat
2317: , RA_CUSTOMER_TRX_LINES_ALL ratl
2318: WHERE rat.customer_trx_id = ratl.customer_trx_id
2319: AND ratl.line_type = 'LINE'
2320: AND ratl.sales_order = to_char(l_movement_transaction.order_number)

Line 2333: RA_CUSTOMER_TRX_ALL rat

2329: , rat.customer_trx_id
2330: , ratl.extended_amount
2331: , NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity)
2332: FROM
2333: RA_CUSTOMER_TRX_ALL rat
2334: , RA_CUSTOMER_TRX_LINES_ALL ratl
2335: , mtl_material_transactions mmt
2336: WHERE rat.customer_trx_id = ratl.customer_trx_id
2337: AND ratl.line_type = 'LINE'

Line 2352: RA_CUSTOMER_TRX_ALL rat

2348: , rat.customer_trx_id
2349: , ratl.extended_amount
2350: , NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity)
2351: FROM
2352: RA_CUSTOMER_TRX_ALL rat
2353: , RA_CUSTOMER_TRX_LINES_ALL ratl
2354: WHERE rat.customer_trx_id = ratl.customer_trx_id
2355: AND ratl.line_type = 'LINE'
2356: AND ratl.sales_order = to_char(l_movement_transaction.order_number)

Line 2389: --, ra_customer_trx_all rcta

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
2391: -- AND (NVL(aida.match_status_flag,'N') = 'A'
2392: -- OR (NVL(aida.match_status_flag,'N') = 'T'
2393: -- AND aia.wfapproval_status = 'NOT REQUIRED'))

Line 2415: , ra_customer_trx_all rcta

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
2418: AND aila.line_type_lookup_code = 'ITEM'
2419: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2449: , ra_customer_trx_all rcta

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
2452: , mtl_material_transactions mmt
2453: WHERE aia.invoice_id = aila.invoice_id

Line 2491: , ra_customer_trx_all rcta

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
2494: AND aia.cancelled_date IS NULL
2495: AND aila.line_type_lookup_code = 'ITEM'

Line 2527: , ra_customer_trx_all rcta

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
2530: AND aila.line_type_lookup_code = 'ITEM'
2531: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2572: , ra_customer_trx_all rcta

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
2575: AND aia.cancelled_date IS NULL
2576: AND aila.line_type_lookup_code = 'ITEM'

Line 2725: , RA_CUSTOMER_TRX_ALL rctl

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:
2729: -- Cursor to get all the invoice information for drop shipments after fetching

Line 2741: RA_CUSTOMER_TRX_ALL rat

2737: , rat.exchange_rate_type
2738: , rat.exchange_date
2739: , NVL(rat.invoice_currency_code,l_movement_transaction.currency_code)
2740: FROM
2741: RA_CUSTOMER_TRX_ALL rat
2742: , RA_CUSTOMER_TRX_LINES_ALL ratl
2743: WHERE rat.customer_trx_id = ratl.customer_trx_id
2744: --AND ratl.quantity_invoiced = ratl.quantity_ordered
2745: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'