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_CUST_TRX_TYPES_ALL

Line 334: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 361: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 443: , RA_CUST_TRX_TYPES_ALL ratt --add in for fixing bug 2447381

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

Line 471: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 556: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 582: , RA_CUST_TRX_TYPES_ALL ratt

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
586: AND ratt.type IN ('CM','DM')

Line 910: , RA_CUST_TRX_TYPES_ALL ratt

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
914: AND ratt.type NOT IN ('CM','DM')

Line 1051: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 2151: , RA_CUST_TRX_TYPES_ALL ratt

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
2155: AND ratt.type NOT IN ('CM','DM')

Line 2180: , RA_CUST_TRX_TYPES_ALL ratt

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
2184: AND ratt.type IN ('CM','DM')

Line 2203: , RA_CUST_TRX_TYPES_ALL ratt

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
2207: AND ((ratt.type IN ('CM','DM'))

Line 2253: , RA_CUST_TRX_TYPES_ALL ratt --add in for fixing bug 2447381

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

Line 2281: , RA_CUST_TRX_TYPES_ALL ratt

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