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 OE_ORDER_LINES_ALL

Line 335: , oe_order_lines_all oola

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

Line 362: , oe_order_lines_all oola

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

Line 444: , oe_order_lines_all oola

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

Line 472: , oe_order_lines_all oola

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

Line 556: , oe_order_lines_all oola

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

Line 624: , oe_order_lines_all oola

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
628: AND oola.top_model_line_id = p_order_line_id

Line 694: , oe_order_lines_all oola

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

Line 838: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

834: )
835: IS
836: l_line_id NUMBER;
837: l_model_line_id NUMBER;
838: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
839: l_invoiced_line_qty NUMBER;
840: l_total_invoiced_qty NUMBER :=0;
841: l_line_freight_charge NUMBER;
842: l_total_line_charge NUMBER := 0;

Line 867: oe_order_lines_all

863: SELECT
864: item_type_code
865: , top_model_line_id
866: FROM
867: oe_order_lines_all
868: WHERE line_id = p_movement_transaction.order_line_id;
869:
870: --Calculate the invoice quantity for an order line
871: CURSOR c_invoiced_line_qty IS

Line 1003: , oe_order_lines_all oola

999: SELECT
1000: count(transaction_id)
1001: FROM
1002: rcv_transactions rt
1003: , oe_order_lines_all oola
1004: WHERE rt.oe_order_line_id = oola.line_id
1005: AND oola.reference_line_id = to_char(p_movement_transaction.order_line_id)
1006: AND rt.mvt_stat_status = 'PROCESSED'
1007: AND rt.source_document_code = 'RMA';

Line 1019: , OE_ORDER_LINES_ALL oola

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

Line 1984: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

1980: l_uom_code VARCHAR2(3);
1981: l_parent_transaction_id NUMBER;
1982: l_so_le_id NUMBER;
1983: l_shipping_le_id NUMBER;
1984: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1985: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1986: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1987:
1988: --fix bug2861110

Line 1985: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;

1981: l_parent_transaction_id NUMBER;
1982: l_so_le_id NUMBER;
1983: l_shipping_le_id NUMBER;
1984: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1985: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1986: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1987:
1988: --fix bug2861110
1989: l_processed_ret_amt NUMBER;

Line 1986: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;

1982: l_so_le_id NUMBER;
1983: l_shipping_le_id NUMBER;
1984: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1985: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1986: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
1987:
1988: --fix bug2861110
1989: l_processed_ret_amt NUMBER;
1990: l_processed_ret_qty NUMBER;

Line 2598: oe_order_lines_all

2594: SELECT
2595: item_type_code
2596: , top_model_line_id
2597: FROM
2598: oe_order_lines_all
2599: WHERE line_id = l_movement_transaction.order_line_id;
2600:
2601: --Cursor to get total rtv transaction quantity
2602: CURSOR l_total_rtv_quantity IS

Line 3175: FROM oe_order_lines_all

3171: --qty for each receipt
3172: --Get total return qty
3173: SELECT ordered_quantity
3174: INTO l_total_rma_qty
3175: FROM oe_order_lines_all
3176: WHERE line_id = l_movement_transaction.order_line_id;
3177:
3178: x_movement_transaction.invoice_quantity :=
3179: (l_movement_transaction.transaction_quantity/l_total_rma_qty)