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 555: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 877: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 1018: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 2032: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 2061: , RA_CUST_TRX_TYPES_ALL ratt

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

Line 2084: , RA_CUST_TRX_TYPES_ALL ratt

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

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

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

Line 2142: , RA_CUST_TRX_TYPES_ALL ratt

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