152:
153: -- Cursor to get om rma org id
154: CURSOR c_get_om_rma_org_id (p_repair_line_id in number) IS
155: SELECT oel.ship_from_org_id
156: FROM oe_order_lines_all oel,
157: csd_repairs cr
158: WHERE
159: cr.repair_line_id = p_repair_line_id
160: AND cr.original_source_header_id = oel.header_id
162:
163: -- Cursor to get ro rma org id
164: CURSOR c_get_ro_rma_org_id (p_repair_line_id in number) IS
165: SELECT oel.ship_from_org_Id
166: FROM oe_order_lines_all oel,
167: csd_product_transactions cp
168: WHERE cp.repair_line_id = p_repair_line_Id
169: AND cp.action_type in ('RMA','MOVE_IN')
170: AND cp.order_line_id = oel.line_id