[Home] [Help]
37: x_repair_number ,
38: x_repair_line_id,
39: x_quantity
40: FROM cs_estimate_details a,
41: csd_repairs b
42: WHERE ((a.original_source_id = b.repair_line_id
43: AND a.original_source_code = 'DR') OR
44: (a.source_id = b.repair_line_id
45: AND a.source_code = 'DR'))
187: And rcvt.organization_id = hou.organization_id
188: AND rcvt.transaction_id NOT IN
189: (SELECT paramn1
190: FROM csd_Repair_history crh,
191: csd_repairs cra
192: WHERE crh.repair_line_id = cra.repair_line_id
193: AND event_code='RR'
194: AND cra.repair_line_id = nvl(p_repair_line_id,cra.repair_line_id)) -- travi 020903 change
195: AND EXISTS (SELECT ced.order_header_id
192: WHERE crh.repair_line_id = cra.repair_line_id
193: AND event_code='RR'
194: AND cra.repair_line_id = nvl(p_repair_line_id,cra.repair_line_id)) -- travi 020903 change
195: AND EXISTS (SELECT ced.order_header_id
196: FROM csd_repairs cra,
197: cs_estimate_details ced
198: WHERE ((cra.repair_line_id = ced.original_source_id
199: AND ced.original_source_code = 'DR') OR
200: (cra.repair_line_id = ced.source_id
223: , dra.serial_number dr_sl_number
224: , cpt.inventory_item_id pt_item_id
225: , dra.inventory_item_id dr_item_id
226: from csd_product_txns_v cpt
227: , csd_repairs dra
228: where action_type = 'RMA'
229: and dra.repair_line_id = p_rep_line_id
230: and cpt.repair_line_id = dra.repair_line_id
231: and nvl(cpt.serial_number_control_code,1) > 1;
559: csd_gen_utility_pvt.add('p_result_quantity='|| TO_CHAR(p_result_quantity));
560: END IF;
561:
562:
563: update csd_repairs
564: set quantity_rcvd = nvl(quantity_rcvd,0)+nvl(p_result_quantity,0)
565: where repair_line_id = l_repair_line_id;
566:
567: For P in c_prod_txn_stat_upd ( l_repair_line_id )
811: crj.quantity,
812: csr.promise_date,
813: crj.organization_id
814: from CSD_REPAIR_JOB_XREF CRJ
815: ,CSD_REPAIRS csr
816: where
817: csr.repair_line_id = crj.repair_line_id
818: and
819: nvl(crj.quantity_completed,0) < crj.quantity
1123:
1124: v_total_records number;
1125:
1126: Cursor DEPOT_SHIPMENT_LINES ( p_repair_line_id number) is
1127: select /*+ index(cra CSD_REPAIRS_U1) */
1128: dd.serial_number sl_number, -- travi 012502
1129: cra.quantity qty, -- travi 012502
1130: dd.lot_number lot_number, --vijay 02/03/2003
1131: dd.revision revision, --vijay 02/03/2003
1150: wsh_delivery_assignments da,
1151: wsh_delivery_details dd ,
1152: oe_order_headers_all oeh,
1153: oe_order_lines_all oel,
1154: csd_Repairs cra,
1155: cs_estimate_Details ced,
1156: mtl_units_of_measure mtlu
1157: Where ((cra.repair_line_id = ced.original_source_id
1158: and ced.original_source_code = 'DR') OR
1189:
1190: Cursor c_prd_txn_serial_num ( p_rep_line_id number ) is
1191: select nvl(cpt.serial_number, dra.serial_number) serial_number
1192: from csd_product_txns_v cpt
1193: , csd_repairs dra
1194: where action_type = 'SHIP'
1195: and dra.repair_line_id = p_rep_line_id
1196: and cpt.repair_line_id = dra.repair_line_id
1197: and nvl(cpt.serial_number_control_code,1) > 1;
1439: i.shipped_uom,
1440: i.shipped_quantity,
1441: p_result_ship_quantity);
1442:
1443: update csd_repairs
1444: set quantity_shipped = nvl(quantity_shipped,0)+nvl(p_result_ship_quantity,0)
1445: where repair_line_id = I.repair_line_id;
1446:
1447: --Vijay 2/3/03 Begin
1453:
1454: --Vijay 2/3/03 End
1455:
1456: IF (g_debug > 0 ) THEN
1457: csd_gen_utility_pvt.add('Updated csd_repairs table');
1458: END IF;
1459:
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1629: ,rep.repair_line_id
1630: --,max(hist.repair_history_id) repair_history_id
1631: from csd_repair_tasks_v tsk
1632: ,csd_repair_history hist
1633: ,csd_repairs rep
1634: where rep.repair_line_id = tsk.source_object_id
1635: and tsk.source_object_id = hist.repair_line_id
1636: and tsk.task_id = hist.paramn1
1637: and ( tsk.task_status_id <> hist.paramn5 or tsk.owner_id <> hist.paramn3)