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 557: , oe_order_lines_all oola

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

Line 592: ( SELECT DISTINCT To_Char(ol.line_id) FROM oe_order_lines_all ol

588: AND ratl.quantity_credited IS NOT NULL
589: AND NVL(UPPER(ratl.sales_order_source),'ORDER ENTRY') = 'ORDER ENTRY'
590: AND NVL(ratl.org_id,0) = NVL(p_org_id,0)
591: AND ratl.interface_line_attribute6 In
592: ( SELECT DISTINCT To_Char(ol.line_id) FROM oe_order_lines_all ol
593: WHERE (return_attribute1,return_attribute2) IN
594: (SELECT to_char(header_id),to_char(line_id) FROM oe_order_lines_all ol1
595: WHERE (header_id,Top_model_line_id) IN
596: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol

Line 594: (SELECT to_char(header_id),to_char(line_id) FROM oe_order_lines_all ol1

590: AND NVL(ratl.org_id,0) = NVL(p_org_id,0)
591: AND ratl.interface_line_attribute6 In
592: ( SELECT DISTINCT To_Char(ol.line_id) FROM oe_order_lines_all ol
593: WHERE (return_attribute1,return_attribute2) IN
594: (SELECT to_char(header_id),to_char(line_id) FROM oe_order_lines_all ol1
595: WHERE (header_id,Top_model_line_id) IN
596: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol
597: WHERE ol.line_id=p_order_line_id )))
598: AND ratl.interface_line_attribute1 = p_order_number

Line 596: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol

592: ( SELECT DISTINCT To_Char(ol.line_id) FROM oe_order_lines_all ol
593: WHERE (return_attribute1,return_attribute2) IN
594: (SELECT to_char(header_id),to_char(line_id) FROM oe_order_lines_all ol1
595: WHERE (header_id,Top_model_line_id) IN
596: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol
597: WHERE ol.line_id=p_order_line_id )))
598: AND ratl.interface_line_attribute1 = p_order_number
599: AND ratl.interface_line_context <> 'INTERCOMPANY';
600: /*End bug 8435314 */

Line 657: , oe_order_lines_all oola

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

Line 727: , oe_order_lines_all oola

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

Line 871: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

867: )
868: IS
869: l_line_id NUMBER;
870: l_model_line_id NUMBER;
871: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
872: l_invoiced_line_qty NUMBER;
873: l_total_invoiced_qty NUMBER :=0;
874: l_line_freight_charge NUMBER;
875: l_total_line_charge NUMBER := 0;

Line 900: oe_order_lines_all

896: SELECT
897: item_type_code
898: , top_model_line_id
899: FROM
900: oe_order_lines_all
901: WHERE line_id = p_movement_transaction.order_line_id;
902:
903: --Calculate the invoice quantity for an order line
904: CURSOR c_invoiced_line_qty IS

Line 1036: , oe_order_lines_all oola

1032: SELECT
1033: count(transaction_id)
1034: FROM
1035: rcv_transactions rt
1036: , oe_order_lines_all oola
1037: WHERE rt.oe_order_line_id = oola.line_id
1038: AND oola.reference_line_id = to_char(p_movement_transaction.order_line_id)
1039: AND rt.mvt_stat_status = 'PROCESSED'
1040: AND rt.source_document_code = 'RMA';

Line 1052: , OE_ORDER_LINES_ALL oola

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

Line 2103: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

2099: l_uom_code VARCHAR2(3);
2100: l_parent_transaction_id NUMBER;
2101: l_so_le_id NUMBER;
2102: l_shipping_le_id NUMBER;
2103: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
2104: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2105: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2106:
2107: --fix bug2861110

Line 2104: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;

2100: l_parent_transaction_id NUMBER;
2101: l_so_le_id NUMBER;
2102: l_shipping_le_id NUMBER;
2103: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
2104: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2105: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2106:
2107: --fix bug2861110
2108: l_processed_ret_amt NUMBER;

Line 2105: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;

2101: l_so_le_id NUMBER;
2102: l_shipping_le_id NUMBER;
2103: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
2104: l_model_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2105: l_cto_line_id OE_ORDER_LINES_ALL.Line_Id%TYPE;
2106:
2107: --fix bug2861110
2108: l_processed_ret_amt NUMBER;
2109: l_processed_ret_qty NUMBER;

Line 2230: SELECT DISTINCT ol.line_id FROM oe_order_lines_all ol

2226: AND auto_created_config_flag = 'Y'
2227: AND base_item_id IS NOT null;
2228:
2229: CURSOR l_rma_model_id IS
2230: SELECT DISTINCT ol.line_id FROM oe_order_lines_all ol
2231: WHERE (return_attribute1,return_attribute2) IN
2232: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol1
2233: WHERE (header_id,Top_model_line_id) IN
2234: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol2

Line 2232: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol1

2228:
2229: CURSOR l_rma_model_id IS
2230: SELECT DISTINCT ol.line_id FROM oe_order_lines_all ol
2231: WHERE (return_attribute1,return_attribute2) IN
2232: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol1
2233: WHERE (header_id,Top_model_line_id) IN
2234: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol2
2235: WHERE (header_id,line_id ) IN
2236: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol3

Line 2234: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol2

2230: SELECT DISTINCT ol.line_id FROM oe_order_lines_all ol
2231: WHERE (return_attribute1,return_attribute2) IN
2232: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol1
2233: WHERE (header_id,Top_model_line_id) IN
2234: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol2
2235: WHERE (header_id,line_id ) IN
2236: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol3
2237: WHERE ol3.line_id=l_movement_transaction.order_line_id
2238: AND ol3.header_id=l_movement_transaction.order_header_id)))

Line 2236: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol3

2232: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol1
2233: WHERE (header_id,Top_model_line_id) IN
2234: (SELECT header_id,Top_model_line_id FROM oe_order_lines_all ol2
2235: WHERE (header_id,line_id ) IN
2236: (SELECT return_attribute1,return_attribute2 FROM oe_order_lines_all ol3
2237: WHERE ol3.line_id=l_movement_transaction.order_line_id
2238: AND ol3.header_id=l_movement_transaction.order_header_id)))
2239: AND ol.header_id=l_movement_transaction.order_header_id;
2240: /*End bug 8435314*/

Line 3076: oe_order_lines_all

3072: SELECT
3073: item_type_code
3074: , top_model_line_id
3075: FROM
3076: oe_order_lines_all
3077: WHERE line_id = l_movement_transaction.order_line_id;
3078:
3079: --Cursor to get total rtv transaction quantity
3080: CURSOR l_total_rtv_quantity IS

Line 3928: FROM oe_order_lines_all

3924: --qty for each receipt
3925: --Get total return qty
3926: SELECT ordered_quantity
3927: INTO l_total_rma_qty
3928: FROM oe_order_lines_all
3929: WHERE line_id = l_movement_transaction.order_line_id;
3930:
3931: x_movement_transaction.invoice_quantity :=
3932: (l_movement_transaction.transaction_quantity/l_total_rma_qty)