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.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_INSTANCE_INTERFACE

Line 14: SELECT instance_id FROM csi_instance_interface

10: l_serial_code NUMBER;
11: l_fnd_unexpected VARCHAR2(1);
12: e_exists EXCEPTION;
13: CURSOR instance_id_cur(p_interface_id IN NUMBER) IS
14: SELECT instance_id FROM csi_instance_interface
15: WHERE inst_interface_id = p_interface_id;
16:
17: CURSOR serial_cur(p_interface_id IN NUMBER) IS
18: SELECT cii.instance_id

Line 20: csi_instance_interface cii

16:
17: CURSOR serial_cur(p_interface_id IN NUMBER) IS
18: SELECT cii.instance_id
19: FROM csi_item_instances csi,
20: csi_instance_interface cii
21: WHERE cii.inst_interface_id = p_interface_id
22: AND csi.inventory_item_id = cii.inventory_item_id
23: AND csi.serial_number = cii.serial_number;
24:

Line 29: csi_instance_interface c,

25: CURSOR nonserial_cur(p_interface_id IN NUMBER) IS
26: SELECT a.instance_id
27: FROM csi_item_instances a,
28: csi_i_parties b,
29: csi_instance_interface c,
30: csi_i_party_interface d
31: WHERE a.instance_id = b.instance_id
32: AND a.inventory_item_id = c.inventory_item_id
33: AND c.inst_interface_id = d.inst_interface_id

Line 48: csi_instance_interface cii

44:
45: CURSOR serial_control_cur(p_interface_id IN NUMBER) IS
46: select msi.serial_number_control_code
47: from mtl_system_items msi,
48: csi_instance_interface cii
49: where msi.inventory_item_id = cii.inventory_item_id
50: and msi.organization_id = cii.inv_organization_id
51: and cii.inst_interface_id = p_interface_id;
52:

Line 201: FROM csi_instance_interface cii

197: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
198: CURSOR get_txns_cur( p_source_system IN VARCHAR2,
199: p_batch IN VARCHAR2) IS
200: SELECT distinct transaction_identifier
201: FROM csi_instance_interface cii
202: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch,cii.batch_name)
203: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch,'$CSI_NULL_VALUE$'))
204: AND cii.source_system_name = p_source_system
205: AND trunc(cii.source_transaction_date) BETWEEN nvl(p_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(p_txn_to_date,trunc(cii.source_transaction_date))

Line 211: FROM csi_instance_interface cii

207:
208: CURSOR iface_det_cur(p_txn_ident IN VARCHAR2,
209: p_source_system IN VARCHAR2) IS
210: SELECT cii.*
211: FROM csi_instance_interface cii
212: WHERE cii.transaction_identifier = p_txn_ident
213: AND cii.source_system_name = p_source_system
214: AND cii.process_status = 'R';
215:

Line 265: csi_instance_interface cii1,

261: cii2.instance_id new_object_id,
262: cii1.source_transaction_date source_transaction_date,
263: cii1.transaction_identifier transaction_identifier
264: FROM csi_ii_relation_interface ciri,
265: csi_instance_interface cii1,
266: csi_instance_interface cii2
267: WHERE ciri.subject_interface_id = cii1.inst_interface_id
268: AND cii1.transaction_identifier = p_txn_ident
269: AND cii1.source_system_name = p_source_system

Line 266: csi_instance_interface cii2

262: cii1.source_transaction_date source_transaction_date,
263: cii1.transaction_identifier transaction_identifier
264: FROM csi_ii_relation_interface ciri,
265: csi_instance_interface cii1,
266: csi_instance_interface cii2
267: WHERE ciri.subject_interface_id = cii1.inst_interface_id
268: AND cii1.transaction_identifier = p_txn_ident
269: AND cii1.source_system_name = p_source_system
270: AND ciri.object_interface_id = cii2.inst_interface_id

Line 343: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE

339: END LOOP;
340: --
341: IF l_intf_id_array.count > 0 THEN
342: BEGIN
343: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
344: SET error_text = :error_text
345: ,process_status = :status
346: WHERE inst_interface_id = :intf_id';
347: l_num_of_rows := dbms_sql.open_cursor;

Line 388: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE

384: END LOOP;
385: --
386: IF l_intf_id_array.count > 0 THEN
387: BEGIN
388: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
389: SET error_text = :error_text
390: ,process_status = :status
391: WHERE inst_interface_id = :intf_id';
392: l_num_of_rows := dbms_sql.open_cursor;

Line 430: UPDATE CSI_INSTANCE_INTERFACE a

426:
427: l_txn_type_id := cse_util_pkg.get_txn_type_id('OPEN_INTERFACE','CSI');
428:
429:
430: UPDATE CSI_INSTANCE_INTERFACE a
431: SET a.instance_id = (SELECT b.instance_id
432: FROM csi_item_instances b
433: WHERE a.instance_number = b.instance_number)
434: WHERE a.instance_number IS NOT NULL

Line 443: UPDATE CSI_INSTANCE_INTERFACE cii

439: BEGIN
440: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
441: l_error_message := fnd_message.get;
442:
443: UPDATE CSI_INSTANCE_INTERFACE cii
444: SET error_text =l_error_message , process_status ='E'
445: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
446: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))
447: AND cii.source_system_name = p_source_system_name

Line 483: UPDATE CSI_INSTANCE_INTERFACE cii

479: BEGIN
480: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
481: l_error_message := fnd_message.get;
482:
483: UPDATE CSI_INSTANCE_INTERFACE cii
484: SET error_text =l_error_message
485: ,process_status ='E'
486: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
487: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 510: UPDATE CSI_INSTANCE_INTERFACE cii

506:
507: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
508: l_error_message := fnd_message.get;
509:
510: UPDATE CSI_INSTANCE_INTERFACE cii
511: SET error_text =l_error_message
512: ,process_status ='E'
513: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
514: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 534: UPDATE CSI_INSTANCE_INTERFACE cii

530:
531: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
532: l_error_message := fnd_message.get;
533:
534: UPDATE CSI_INSTANCE_INTERFACE cii
535: SET error_text =l_error_message
536: ,process_status ='E'
537: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
538: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 2663: update csi_instance_interface

2659: --u_instance_tbl(inst_idx).instance_id := l_instance_id;
2660: u_instance_tbl(u_inst_idx).instance_id := l_instance_id; --Added for open
2661: -- call resolve_update_ids
2662: BEGIN
2663: update csi_instance_interface
2664: set instance_id = l_instance_id
2665: where inst_interface_id = iface_Det_rec.inst_interface_id;
2666: END;
2667:

Line 2842: UPDATE csi_instance_interface

2838: IF u_instance_tbl(i).processed_flag = 'E'
2839: THEN
2840: RAISE g_upd_error;
2841: ELSE
2842: UPDATE csi_instance_interface
2843: SET process_status = 'P'
2844: WHERE instance_id = u_instance_tbl(i).instance_id;
2845: END IF;
2846: END IF;

Line 3069: UPDATE csi_instance_interface

3065:
3066: WHEN g_exc_error THEN
3067: FND_File.Put_Line(Fnd_File.LOG,'error:'||l_error_message);
3068: ROLLBACK TO s_txnbegin;
3069: UPDATE csi_instance_interface
3070: SET process_Status = 'E',
3071: error_text = l_error_message
3072: WHERE transaction_identifier = get_txns_rec.transaction_identifier
3073: AND source_system_name = p_source_system_name;