APPS.RMA_UPDATE dependencies on MTL_SO_RMA_INTERFACE

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 30: UPDATE mtl_so_rma_interface msri

26: WHERE mt.transaction_header_id = header_id_value
27: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
28:
29:
30: UPDATE mtl_so_rma_interface msri
31: SET msri.received_quantity = (SELECT
32: decode(sign(sum(mt.department_id) + msri.delivered_quantity -
33: msri.received_quantity),-1,
34: msri.received_quantity, 1, sum(mt.department_id) +

Line 82: FROM mtl_so_rma_interface msri, mtl_material_transactions mt

78: 0, 1, mt.department_id +
79: msri.delivered_quantity - msri.received_quantity, 0),
80: mt.department_id,msri.unit_code,mt.transaction_date,mt.subinventory_code,mt.last_update_date,mt.last_updated_by,
81: mt.creation_date,mt.created_by
82: FROM mtl_so_rma_interface msri, mtl_material_transactions mt
83: WHERE mt.transaction_set_id = header_id_value
84: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
85:
86: UPDATE mtl_so_rma_interface msri

Line 86: UPDATE mtl_so_rma_interface msri

82: FROM mtl_so_rma_interface msri, mtl_material_transactions mt
83: WHERE mt.transaction_set_id = header_id_value
84: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
85:
86: UPDATE mtl_so_rma_interface msri
87: SET msri.received_quantity = (SELECT
88: decode(sign(sum(mt.department_id) + msri.delivered_quantity -
89: msri.received_quantity),-1,
90: msri.received_quantity, 1, sum(mt.department_id) +

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 144: UPDATE mtl_so_rma_interface msri

140: WHERE mt.transaction_header_id = header_id_value
141: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
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 ),

Line 185: FROM mtl_so_rma_interface msri, mtl_material_transactions mt

181: SELECT
182: mt.transaction_id,mt.trx_source_delivery_id,mt.organization_id,mt.inventory_item_id, mt.department_id * -1,
183: mt.department_id * -1, msri.unit_code,mt.transaction_date,mt.subinventory_code,mt.last_update_date,
184: mt.last_updated_by,mt.creation_date,mt.created_by
185: FROM mtl_so_rma_interface msri, mtl_material_transactions mt
186: WHERE mt.transaction_set_id = header_id_value
187: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
188:
189: UPDATE mtl_so_rma_interface msri

Line 189: UPDATE mtl_so_rma_interface msri

185: FROM mtl_so_rma_interface msri, mtl_material_transactions mt
186: WHERE mt.transaction_set_id = header_id_value
187: AND mt.trx_source_delivery_id = msri.rma_interface_id ;
188:
189: UPDATE mtl_so_rma_interface msri
190: SET msri.received_quantity = (SELECT msri.received_quantity - sum(mt.department_id)
191: FROM mtl_material_transactions mt
192: WHERE mt.transaction_set_id = header_id_value
193: AND mt.trx_source_delivery_id = msri.rma_interface_id ),