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.RMA_UPDATE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 9: DELETE FROM mtl_material_transactions_temp

5:
6:
7: BEGIN
8:
9: DELETE FROM mtl_material_transactions_temp
10: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
11:
12:
13: INSERT INTO mtl_so_rma_receipts(

Line 25: FROM mtl_so_rma_interface msri, mtl_material_transactions_temp mt

21: 0, 1, mt.department_id +
22: msri.delivered_quantity - msri.received_quantity, 0),
23: mt.department_id,msri.unit_code,mt.transaction_date,mt.subinventory_code,
24: mt.last_update_date,mt.last_updated_by,mt.creation_date,mt.created_by
25: FROM mtl_so_rma_interface msri, mtl_material_transactions_temp mt
26: WHERE mt.transaction_header_id = header_id_value
27: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
28:
29:

Line 37: FROM mtl_material_transactions_temp mt

33: msri.received_quantity),-1,
34: msri.received_quantity, 1, sum(mt.department_id) +
35: msri.delivered_quantity,
36: msri.received_quantity)
37: FROM mtl_material_transactions_temp mt
38: WHERE mt.transaction_header_id = header_id_value
39: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
40: msri.delivered_quantity = (SELECT sum(mt.department_id) +
41: msri.delivered_quantity

Line 42: FROM mtl_material_transactions_temp mt

38: WHERE mt.transaction_header_id = header_id_value
39: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
40: msri.delivered_quantity = (SELECT sum(mt.department_id) +
41: msri.delivered_quantity
42: FROM mtl_material_transactions_temp mt
43: WHERE mt.transaction_header_id = header_id_value
44: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
45:
46: msri.last_update_date = (SELECT mt.last_update_date FROM

Line 47: mtl_material_transactions_temp mt

43: WHERE mt.transaction_header_id = header_id_value
44: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
45:
46: msri.last_update_date = (SELECT mt.last_update_date FROM
47: mtl_material_transactions_temp mt
48: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
49: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
50: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
51: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id FROM

Line 49: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt

45:
46: msri.last_update_date = (SELECT mt.last_update_date FROM
47: mtl_material_transactions_temp mt
48: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
49: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
50: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
51: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id FROM
52: mtl_material_transactions_temp mmtt
53: WHERE mmtt.transaction_header_id = header_id_value) ;

Line 52: mtl_material_transactions_temp mmtt

48: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
49: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
50: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
51: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id FROM
52: mtl_material_transactions_temp mmtt
53: WHERE mmtt.transaction_header_id = header_id_value) ;
54:
55: success := TRUE;
56: EXCEPTION

Line 68: DELETE FROM mtl_material_transactions_temp

64: sql_done boolean := TRUE;
65:
66: BEGIN
67:
68: DELETE FROM mtl_material_transactions_temp
69: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
70:
71: INSERT INTO mtl_so_rma_receipts(
72: RMA_RECEIPT_ID,RMA_INTERFACE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID,RECEIVED_QUANTITY,ACCEPTED_QUANTITY,UNIT_CODE,

Line 128: DELETE FROM mtl_material_transactions_temp

124: Procedure update_rma_returns(header_id_value number, trx_rma_id number, success OUT NOCOPY /* file.sql.39 change */ boolean) IS
125: sql_done boolean := TRUE ;
126: BEGIN
127:
128: DELETE FROM mtl_material_transactions_temp
129: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
130:
131:
132: INSERT INTO mtl_so_rma_receipts(

Line 139: FROM mtl_so_rma_interface msri, mtl_material_transactions_temp mt

135: SELECT
136: mt.transaction_temp_id,mt.trx_source_delivery_id,mt.organization_id,mt.inventory_item_id, mt.department_id * -1,
137: mt.department_id * -1, msri.unit_code,mt.transaction_date,mt.subinventory_code,mt.last_update_date,
138: mt.last_updated_by,mt.creation_date,mt.created_by
139: FROM mtl_so_rma_interface msri, mtl_material_transactions_temp mt
140: WHERE mt.transaction_header_id = header_id_value
141: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
142:
143:

Line 146: FROM mtl_material_transactions_temp mt

142:
143:
144: UPDATE mtl_so_rma_interface msri
145: SET msri.received_quantity = (SELECT msri.received_quantity - sum(mt.department_id)
146: FROM mtl_material_transactions_temp mt
147: WHERE mt.transaction_header_id = header_id_value
148: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
149: msri.delivered_quantity = (select msri.delivered_quantity - sum(mt.department_id)
150: FROM mtl_material_transactions_temp mt

Line 150: FROM mtl_material_transactions_temp mt

146: FROM mtl_material_transactions_temp mt
147: WHERE mt.transaction_header_id = header_id_value
148: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
149: msri.delivered_quantity = (select msri.delivered_quantity - sum(mt.department_id)
150: FROM mtl_material_transactions_temp mt
151: WHERE mt.transaction_header_id = header_id_value
152: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
153: msri.last_update_date = (SELECT mt.last_update_date FROM mtl_material_transactions_temp mt
154: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),

Line 153: msri.last_update_date = (SELECT mt.last_update_date FROM mtl_material_transactions_temp mt

149: msri.delivered_quantity = (select msri.delivered_quantity - sum(mt.department_id)
150: FROM mtl_material_transactions_temp mt
151: WHERE mt.transaction_header_id = header_id_value
152: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
153: msri.last_update_date = (SELECT mt.last_update_date FROM mtl_material_transactions_temp mt
154: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
155: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
156: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
157: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id

Line 155: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt

151: WHERE mt.transaction_header_id = header_id_value
152: AND mt.trx_source_delivery_id = msri.rma_interface_id ),
153: msri.last_update_date = (SELECT mt.last_update_date FROM mtl_material_transactions_temp mt
154: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
155: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
156: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
157: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id
158: FROM mtl_material_transactions_temp mmtt
159: WHERE mmtt.transaction_header_id = header_id_value) ;

Line 158: FROM mtl_material_transactions_temp mmtt

154: WHERE mt.transaction_header_id = header_id_value AND rownum = 1),
155: msri.last_updated_by = (SELECT mt.last_updated_by from mtl_material_transactions_temp mt
156: WHERE mt.transaction_header_id = header_id_value AND rownum = 1)
157: WHERE msri.rma_interface_id IN (SELECT mmtt.trx_source_delivery_id
158: FROM mtl_material_transactions_temp mmtt
159: WHERE mmtt.transaction_header_id = header_id_value) ;
160:
161: success := TRUE;
162: EXCEPTION

Line 174: DELETE FROM mtl_material_transactions_temp

170: Procedure update_rma_returns_rpc(header_id_value number, trx_rma_id number, success OUT NOCOPY /* file.sql.39 change */ boolean) IS
171: sql_done boolean := TRUE ;
172: BEGIN
173:
174: DELETE FROM mtl_material_transactions_temp
175: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
176:
177:
178: INSERT INTO mtl_so_rma_receipts(