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_LINES_ALL

Line 333: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
337: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 360: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
364: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 442: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
446: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 470: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
474: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 555: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
559: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 581: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
585: AND rat.org_id = ratt.org_id

Line 656: RA_CUSTOMER_TRX_LINES_ALL ratl

652: CURSOR l_cto_amt_ar IS
653: SELECT
654: SUM(ratl.extended_amount)
655: FROM
656: RA_CUSTOMER_TRX_LINES_ALL ratl
657: , oe_order_lines_all oola
658: WHERE ratl.line_type = 'LINE'
659: AND ratl.interface_line_attribute6 = to_char(oola.line_id)
660: AND ratl.sales_order = p_order_number

Line 725: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
729: AND aia.cancelled_date IS NULL

Line 884: ra_customer_trx_lines_all

880: CURSOR c_order_lines IS
881: SELECT DISTINCT
882: TO_NUMBER(interface_line_attribute6)
883: FROM
884: ra_customer_trx_lines_all
885: WHERE sales_order = to_char(p_movement_transaction.order_number)
886: AND line_type = 'LINE'
887: AND customer_trx_id IN
888: (SELECT customer_trx_id

Line 889: FROM ra_customer_trx_lines_all

885: WHERE sales_order = to_char(p_movement_transaction.order_number)
886: AND line_type = 'LINE'
887: AND customer_trx_id IN
888: (SELECT customer_trx_id
889: FROM ra_customer_trx_lines_all
890: WHERE interface_line_attribute6 = to_char(p_movement_transaction.order_line_id)
891: AND sales_order = to_char(p_movement_transaction.order_number))
892: ORDER BY TO_NUMBER(interface_line_attribute6);
893:

Line 909: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
913: AND rat.org_id = ratt.org_id

Line 1050: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
1054: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 1465: ra_customer_trx_lines_all

1461: CURSOR inv_uom IS
1462: SELECT
1463: uom_code
1464: FROM
1465: ra_customer_trx_lines_all
1466: WHERE customer_trx_line_id = l_movement_transaction.customer_trx_line_id;
1467:
1468: /* Bug 6158521 - Start */
1469: /* Define cursor to the invoice UOM for AP invoices */

Line 1920: ra_customer_trx_lines_all

1916: IS
1917: SELECT
1918: SUM(extended_amount)
1919: FROM
1920: ra_customer_trx_lines_all
1921: WHERE (sales_order = to_char(p_movement_transaction.order_number)
1922: OR sales_order IS NULL) --for manual invoice
1923: AND line_type = 'FREIGHT'
1924: AND customer_trx_id IN

Line 1926: FROM ra_customer_trx_lines_all

1922: OR sales_order IS NULL) --for manual invoice
1923: AND line_type = 'FREIGHT'
1924: AND customer_trx_id IN
1925: (SELECT customer_trx_id
1926: FROM ra_customer_trx_lines_all
1927: WHERE interface_line_attribute6 = to_char(p_movement_transaction.order_line_id)
1928: AND sales_order = to_char(p_movement_transaction.order_number));
1929:
1930: BEGIN

Line 2150: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
2154: AND rat.org_id = ratt.org_id

Line 2179: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
2183: AND rat.org_id = ratt.org_id

Line 2202: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
2206: AND rat.org_id = ratt.org_id

Line 2252: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
2256: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2280: , RA_CUSTOMER_TRX_LINES_ALL ratl

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
2284: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2317: , RA_CUSTOMER_TRX_LINES_ALL ratl

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)
2321: AND ratl.interface_line_attribute6 =

Line 2334: , RA_CUSTOMER_TRX_LINES_ALL ratl

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'
2338: AND ratl.sales_order = to_char(l_movement_transaction.order_number)

Line 2353: , RA_CUSTOMER_TRX_LINES_ALL ratl

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)
2357: AND ratl.interface_line_attribute6 = to_char(l_movement_transaction.order_line_id)

Line 2388: --, RA_CUSTOMER_TRX_LINES_ALL rctla

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

Line 2414: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2418: AND aila.line_type_lookup_code = 'ITEM'

Line 2448: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2452: , mtl_material_transactions mmt

Line 2490: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2494: AND aia.cancelled_date IS NULL

Line 2526: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2530: AND aila.line_type_lookup_code = 'ITEM'

Line 2571: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2575: AND aia.cancelled_date IS NULL

Line 2604: , RA_CUSTOMER_TRX_LINES_ALL rctla

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)
2608: AND rctla.interface_line_attribute6 =

Line 2619: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
2623: WHERE aia.invoice_id = x_movement_transaction.invoice_id

Line 2641: , RA_CUSTOMER_TRX_LINES_ALL rctla

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)
2645: AND rctla.sales_order = to_char(l_movement_transaction.order_number)

Line 2658: , RA_CUSTOMER_TRX_LINES_ALL rctla

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)
2662: AND rctla.sales_order = to_char(l_movement_transaction.order_number)

Line 2675: , RA_CUSTOMER_TRX_LINES_ALL rctla

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)
2679: AND rctla.interface_line_attribute6 =

Line 2705: , RA_CUSTOMER_TRX_LINES_ALL rctla

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)
2709: AND rctla.interface_line_attribute6 =

Line 2742: , RA_CUSTOMER_TRX_LINES_ALL ratl

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'
2746: AND ratl.interface_line_attribute6 = to_char(l_movement_transaction.order_line_id)

Line 3714: /* The invoice quantity is fetched from quantity_credited in RA_CUSTOMER_TRX_LINES_ALL*/

3710: -- bug 5411006, Following IF block is added to get details from AR invoice
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;