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 554: , RA_CUSTOMER_TRX_LINES_ALL ratl

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

Line 623: RA_CUSTOMER_TRX_LINES_ALL ratl

619: CURSOR l_cto_amt_ar IS
620: SELECT
621: SUM(ratl.extended_amount)
622: FROM
623: RA_CUSTOMER_TRX_LINES_ALL ratl
624: , oe_order_lines_all oola
625: WHERE ratl.line_type = 'LINE'
626: AND ratl.interface_line_attribute6 = to_char(oola.line_id)
627: AND ratl.sales_order = p_order_number

Line 692: , RA_CUSTOMER_TRX_LINES_ALL rctla

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
695: WHERE aia.invoice_id = aila.invoice_id
696: AND aia.cancelled_date IS NULL

Line 851: ra_customer_trx_lines_all

847: CURSOR c_order_lines IS
848: SELECT DISTINCT
849: TO_NUMBER(interface_line_attribute6)
850: FROM
851: ra_customer_trx_lines_all
852: WHERE sales_order = to_char(p_movement_transaction.order_number)
853: AND line_type = 'LINE'
854: AND customer_trx_id IN
855: (SELECT customer_trx_id

Line 856: FROM ra_customer_trx_lines_all

852: WHERE sales_order = to_char(p_movement_transaction.order_number)
853: AND line_type = 'LINE'
854: AND customer_trx_id IN
855: (SELECT customer_trx_id
856: FROM ra_customer_trx_lines_all
857: WHERE interface_line_attribute6 = to_char(p_movement_transaction.order_line_id)
858: AND sales_order = to_char(p_movement_transaction.order_number))
859: ORDER BY TO_NUMBER(interface_line_attribute6);
860:

Line 876: , RA_CUSTOMER_TRX_LINES_ALL ratl

872: SELECT
873: SUM(NVL(ratl.quantity_invoiced,0))
874: FROM
875: RA_CUSTOMER_TRX_ALL rat
876: , RA_CUSTOMER_TRX_LINES_ALL ratl
877: , RA_CUST_TRX_TYPES_ALL ratt
878: WHERE rat.customer_trx_id = ratl.customer_trx_id
879: AND rat.cust_trx_type_id = ratt.cust_trx_type_id
880: AND rat.org_id = ratt.org_id

Line 1017: , RA_CUSTOMER_TRX_LINES_ALL ratl

1013: SUM(NVL(ratl.extended_amount,0))
1014: , SUM(NVL(ratl.quantity_credited,0))
1015: FROM
1016: RA_CUSTOMER_TRX_ALL rat
1017: , RA_CUSTOMER_TRX_LINES_ALL ratl
1018: , RA_CUST_TRX_TYPES_ALL ratt
1019: , OE_ORDER_LINES_ALL oola
1020: , RCV_TRANSACTIONS rt
1021: WHERE rat.customer_trx_id = ratl.customer_trx_id

Line 1432: ra_customer_trx_lines_all

1428: CURSOR inv_uom IS
1429: SELECT
1430: uom_code
1431: FROM
1432: ra_customer_trx_lines_all
1433: WHERE customer_trx_line_id = l_movement_transaction.customer_trx_line_id;
1434:
1435: /* Bug 6158521 - Start */
1436: /* Define cursor to the invoice UOM for AP invoices */

Line 1801: ra_customer_trx_lines_all

1797: IS
1798: SELECT
1799: SUM(extended_amount)
1800: FROM
1801: ra_customer_trx_lines_all
1802: WHERE (sales_order = to_char(p_movement_transaction.order_number)
1803: OR sales_order IS NULL) --for manual invoice
1804: AND line_type = 'FREIGHT'
1805: AND customer_trx_id IN

Line 1807: FROM ra_customer_trx_lines_all

1803: OR sales_order IS NULL) --for manual invoice
1804: AND line_type = 'FREIGHT'
1805: AND customer_trx_id IN
1806: (SELECT customer_trx_id
1807: FROM ra_customer_trx_lines_all
1808: WHERE interface_line_attribute6 = to_char(p_movement_transaction.order_line_id)
1809: AND sales_order = to_char(p_movement_transaction.order_number));
1810:
1811: BEGIN

Line 2031: , RA_CUSTOMER_TRX_LINES_ALL ratl

2027: , SUM(ratl.extended_amount)
2028: , SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2029: FROM
2030: RA_CUSTOMER_TRX_ALL rat
2031: , RA_CUSTOMER_TRX_LINES_ALL ratl
2032: , RA_CUST_TRX_TYPES_ALL ratt
2033: WHERE rat.customer_trx_id = ratl.customer_trx_id
2034: AND rat.cust_trx_type_id = ratt.cust_trx_type_id
2035: AND rat.org_id = ratt.org_id

Line 2060: , RA_CUSTOMER_TRX_LINES_ALL ratl

2056: , SUM(ratl.extended_amount)
2057: , SUM(NVL(ratl.quantity_credited,l_movement_transaction.transaction_quantity))
2058: FROM
2059: RA_CUSTOMER_TRX_ALL rat
2060: , RA_CUSTOMER_TRX_LINES_ALL ratl
2061: , RA_CUST_TRX_TYPES_ALL ratt
2062: WHERE rat.customer_trx_id = ratl.customer_trx_id
2063: AND rat.cust_trx_type_id = ratt.cust_trx_type_id
2064: AND rat.org_id = ratt.org_id

Line 2083: , RA_CUSTOMER_TRX_LINES_ALL ratl

2079: SELECT
2080: SUM(ratl.extended_amount)
2081: FROM
2082: RA_CUSTOMER_TRX_ALL rat
2083: , RA_CUSTOMER_TRX_LINES_ALL ratl
2084: , RA_CUST_TRX_TYPES_ALL ratt
2085: WHERE rat.customer_trx_id = ratl.customer_trx_id
2086: AND rat.cust_trx_type_id = ratt.cust_trx_type_id
2087: AND rat.org_id = ratt.org_id

Line 2113: , RA_CUSTOMER_TRX_LINES_ALL ratl

2109: , SUM(ratl.extended_amount)
2110: , SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2111: FROM
2112: RA_CUSTOMER_TRX_ALL rat
2113: , RA_CUSTOMER_TRX_LINES_ALL ratl
2114: , RA_CUST_TRX_TYPES_ALL ratt --add in for fixing bug 2447381
2115: WHERE rat.customer_trx_id = ratl.customer_trx_id
2116: --AND ratl.quantity_invoiced = ratl.quantity_ordered
2117: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2141: , RA_CUSTOMER_TRX_LINES_ALL ratl

2137: SELECT
2138: SUM(ratl.extended_amount)
2139: FROM
2140: RA_CUSTOMER_TRX_ALL rat
2141: , RA_CUSTOMER_TRX_LINES_ALL ratl
2142: , RA_CUST_TRX_TYPES_ALL ratt
2143: WHERE rat.customer_trx_id = ratl.customer_trx_id
2144: --AND ratl.quantity_invoiced = ratl.quantity_ordered
2145: AND rat.cust_trx_type_id = ratt.cust_trx_type_id

Line 2171: , RA_CUSTOMER_TRX_LINES_ALL ratl

2167: , SUM(ratl.extended_amount)
2168: , SUM(NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity))
2169: FROM
2170: RA_CUSTOMER_TRX_ALL rat
2171: , RA_CUSTOMER_TRX_LINES_ALL ratl
2172: WHERE rat.customer_trx_id = ratl.customer_trx_id
2173: AND ratl.line_type = 'LINE'
2174: AND ratl.sales_order = to_char(l_movement_transaction.order_number)
2175: AND ratl.interface_line_attribute6 =

Line 2197: --, RA_CUSTOMER_TRX_LINES_ALL rctla

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

Line 2221: , RA_CUSTOMER_TRX_LINES_ALL rctla

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

Line 2250: , RA_CUSTOMER_TRX_LINES_ALL rctla

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

Line 2263: , RA_CUSTOMER_TRX_LINES_ALL rctla

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

Line 2300: , RA_CUSTOMER_TRX_LINES_ALL ratl

2296: , rat.exchange_date
2297: , NVL(rat.invoice_currency_code,l_movement_transaction.currency_code)
2298: FROM
2299: RA_CUSTOMER_TRX_ALL rat
2300: , RA_CUSTOMER_TRX_LINES_ALL ratl
2301: WHERE rat.customer_trx_id = ratl.customer_trx_id
2302: --AND ratl.quantity_invoiced = ratl.quantity_ordered
2303: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'
2304: AND ratl.interface_line_attribute6 = to_char(l_movement_transaction.order_line_id)

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

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