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_REPAIR_CNTR dependencies on CSD_PRODUCT_TXNS_V

Line 226: from csd_product_txns_v cpt

222: select cpt.serial_number pt_sl_number
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

Line 245: from csd_product_txns_v

241: where transaction_id = p_txn_id;
242:
243: Cursor c_prod_txn_stat_upd ( p_rep_line_id number) is
244: Select product_transaction_id
245: from csd_product_txns_v
246: where repair_line_id = p_rep_line_id
247: and action_type in ( 'RMA','WALK_IN_RECEIPT')
248: and repair_quantity = quantity_rcvd;
249:

Line 1192: from csd_product_txns_v cpt

1188: l_pt_serial_num varchar2(30);
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