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.CSD_DEPOT_UPDATE_PVT dependencies on CSD_REPAIRS

Line 132: from csd_repairs r

128: CURSOR get_xref_id (p_rep_grp_id in number) IS
129: SELECT x.repair_job_xref_id, x.group_id, x.object_version_number
130: FROM csd_repair_job_xref x
131: WHERE x.repair_line_id in ( select r.repair_line_id
132: from csd_repairs r
133: where r.repair_group_id = p_rep_grp_id)
134: AND x.wip_entity_id = x.group_id;
135: -- end travi new 2501113
136:

Line 171: csd_repairs csr

167: crj.quantity_completed,
168: crj.quantity,
169: csr.promise_date
170: FROM csd_repair_job_xref crj,
171: csd_repairs csr
172: WHERE repair_group_id = p_rep_group_id
173: AND csr.repair_line_id = crj.repair_line_id
174: AND nvl(crj.quantity_completed,0) < crj.quantity
175: AND crj.wip_entity_id = p_wip_ent_id;

Line 376: -- Update csd_repairs

372: csd_gen_utility_pvt.add('Updated qty completed in csd_repair_job_xref for :'||C1.wip_entity_id);
373: END IF;
374:
375:
376: -- Update csd_repairs
377: update csd_repairs
378: set ro_txn_status = 'WIP_COMPLETED'
379: where repair_line_id = C3.repair_line_id;
380:

Line 377: update csd_repairs

373: END IF;
374:
375:
376: -- Update csd_repairs
377: update csd_repairs
378: set ro_txn_status = 'WIP_COMPLETED'
379: where repair_line_id = C3.repair_line_id;
380:
381: IF (g_debug > 0 ) THEN

Line 382: csd_gen_utility_pvt.add('Updated txn status in csd_repairs :'||C3.repair_line_id);

378: set ro_txn_status = 'WIP_COMPLETED'
379: where repair_line_id = C3.repair_line_id;
380:
381: IF (g_debug > 0 ) THEN
382: csd_gen_utility_pvt.add('Updated txn status in csd_repairs :'||C3.repair_line_id);
383: END IF;
384:
385:
386: v_total_rec := v_total_rec + 1;

Line 1235: from csd_repairs cr,

1231: rcv.subinventory,
1232: rcv.last_updated_by who_col,
1233: rcv.oe_order_header_id rma_header_id,
1234: rst.serial_num serial_number
1235: from csd_repairs cr,
1236: csd_product_transactions cpt,
1237: cs_estimate_details ced,
1238: rcv_transactions rcv,
1239: rcv_serial_transactions rst,

Line 1261: csd_repairs cra

1257: and rcv.source_document_code = 'RMA'
1258: and rcv.transaction_id NOT IN
1259: (SELECT paramn1
1260: FROM csd_Repair_history crh,
1261: csd_repairs cra
1262: WHERE crh.repair_line_id = cra.repair_line_id
1263: AND crh.event_code = 'RR'
1264: AND cra.repair_group_id = p_rep_group_id );
1265:

Line 1314: -- Update csd_repairs with txn_status

1310:
1311:
1312: IF C1.action_code <> 'LOANER' THEN
1313:
1314: -- Update csd_repairs with txn_status
1315: -- and the rscd_qty
1316: IF (g_debug > 0 ) THEN
1317: csd_gen_utility_pvt.add('Before update csd_repairs');
1318: END IF;

Line 1317: csd_gen_utility_pvt.add('Before update csd_repairs');

1313:
1314: -- Update csd_repairs with txn_status
1315: -- and the rscd_qty
1316: IF (g_debug > 0 ) THEN
1317: csd_gen_utility_pvt.add('Before update csd_repairs');
1318: END IF;
1319:
1320:
1321: update csd_repairs

Line 1321: update csd_repairs

1317: csd_gen_utility_pvt.add('Before update csd_repairs');
1318: END IF;
1319:
1320:
1321: update csd_repairs
1322: set quantity_rcvd = nvl(quantity_rcvd,0)+ nvl(p_result_quantity,0),
1323: ro_txn_status = 'OM_RECEIVED'
1324: where repair_line_id = C1.repair_line_id;
1325:

Line 1327: csd_gen_utility_pvt.add('After update csd_repairs');

1323: ro_txn_status = 'OM_RECEIVED'
1324: where repair_line_id = C1.repair_line_id;
1325:
1326: IF (g_debug > 0 ) THEN
1327: csd_gen_utility_pvt.add('After update csd_repairs');
1328: END IF;
1329:
1330: END IF;
1331:

Line 1436: -- Update csd_repairs with txn_status

1432: fnd_msg_pub.add;
1433: RAISE FND_API.G_EXC_ERROR;
1434: End;
1435:
1436: -- Update csd_repairs with txn_status
1437: -- and the rscd_qty
1438: update csd_repairs
1439: set serial_number = C1.serial_number ,
1440: customer_product_id = l_instance_id

Line 1438: update csd_repairs

1434: End;
1435:
1436: -- Update csd_repairs with txn_status
1437: -- and the rscd_qty
1438: update csd_repairs
1439: set serial_number = C1.serial_number ,
1440: customer_product_id = l_instance_id
1441: where repair_line_id = C1.repair_line_id;
1442:

Line 1445: -- Update csd_repairs with txn_status

1441: where repair_line_id = C1.repair_line_id;
1442:
1443: Else
1444:
1445: -- Update csd_repairs with txn_status
1446: -- and the rscd_qty
1447: update csd_repairs
1448: set serial_number = C1.serial_number
1449: where repair_line_id = C1.repair_line_id;

Line 1447: update csd_repairs

1443: Else
1444:
1445: -- Update csd_repairs with txn_status
1446: -- and the rscd_qty
1447: update csd_repairs
1448: set serial_number = C1.serial_number
1449: where repair_line_id = C1.repair_line_id;
1450:
1451: End If;

Line 1659: csd_Repairs cra,

1655: mtlu.unit_of_measure shipped_uom,
1656: dd.inventory_item_id ,
1657: dd.organization_id
1658: from
1659: csd_Repairs cra,
1660: csd_product_transactions cpt,
1661: cs_estimate_details ced,
1662: wsh_new_deliveries dl,
1663: wsh_delivery_assignments da,

Line 1743: -- Update the csd_repairs table

1739:
1740:
1741: IF I.action_code <> 'LOANER' THEN
1742:
1743: -- Update the csd_repairs table
1744: update csd_repairs
1745: set quantity_shipped = nvl(quantity_shipped,0)+nvl(p_result_ship_quantity,0),
1746: ro_txn_status = 'RO_SHIPPED'
1747: where repair_line_id = I.repair_line_id;

Line 1744: update csd_repairs

1740:
1741: IF I.action_code <> 'LOANER' THEN
1742:
1743: -- Update the csd_repairs table
1744: update csd_repairs
1745: set quantity_shipped = nvl(quantity_shipped,0)+nvl(p_result_ship_quantity,0),
1746: ro_txn_status = 'RO_SHIPPED'
1747: where repair_line_id = I.repair_line_id;
1748: END IF;

Line 1756: csd_gen_utility_pvt.add('Updated csd_repairs table');

1752: set prod_txn_status= 'SHIPPED'
1753: where product_transaction_id = I.product_transaction_id;
1754:
1755: IF (g_debug > 0 ) THEN
1756: csd_gen_utility_pvt.add('Updated csd_repairs table');
1757: END IF;
1758:
1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');