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 207: FROM csi_instance_interface cii

203: -- Bug 9526806
204: CURSOR get_txns_cur( p_source_system IN VARCHAR2,
205: p_batch IN VARCHAR2) IS
206: SELECT distinct transaction_identifier
207: FROM csi_instance_interface cii
208: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch,cii.batch_name)
209: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch,'$CSI_NULL_VALUE$'))
210: AND cii.source_system_name = p_source_system
211: AND trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))

Line 217: FROM csi_instance_interface cii

213:
214: CURSOR iface_det_cur(p_txn_ident IN VARCHAR2,
215: p_source_system IN VARCHAR2) IS
216: SELECT cii.*
217: FROM csi_instance_interface cii
218: WHERE cii.transaction_identifier = p_txn_ident
219: AND cii.source_system_name = p_source_system
220: AND cii.process_status = 'R';
221:

Line 271: csi_instance_interface cii1,

267: cii2.instance_id new_object_id,
268: cii1.source_transaction_date source_transaction_date,
269: cii1.transaction_identifier transaction_identifier
270: FROM csi_ii_relation_interface ciri,
271: csi_instance_interface cii1,
272: csi_instance_interface cii2
273: WHERE ciri.subject_interface_id = cii1.inst_interface_id
274: AND cii1.transaction_identifier = p_txn_ident
275: AND cii1.source_system_name = p_source_system

Line 272: csi_instance_interface cii2

268: cii1.source_transaction_date source_transaction_date,
269: cii1.transaction_identifier transaction_identifier
270: FROM csi_ii_relation_interface ciri,
271: csi_instance_interface cii1,
272: csi_instance_interface cii2
273: WHERE ciri.subject_interface_id = cii1.inst_interface_id
274: AND cii1.transaction_identifier = p_txn_ident
275: AND cii1.source_system_name = p_source_system
276: AND ciri.object_interface_id = cii2.inst_interface_id

Line 349: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE

345: END LOOP;
346: --
347: IF l_intf_id_array.count > 0 THEN
348: BEGIN
349: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
350: SET error_text = :error_text
351: ,process_status = :status
352: WHERE inst_interface_id = :intf_id';
353: l_num_of_rows := dbms_sql.open_cursor;

Line 394: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE

390: END LOOP;
391: --
392: IF l_intf_id_array.count > 0 THEN
393: BEGIN
394: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
395: SET error_text = :error_text
396: ,process_status = :status
397: WHERE inst_interface_id = :intf_id';
398: l_num_of_rows := dbms_sql.open_cursor;

Line 443: UPDATE CSI_INSTANCE_INTERFACE a

439:
440: l_txn_type_id := cse_util_pkg.get_txn_type_id('OPEN_INTERFACE','CSI');
441:
442:
443: UPDATE CSI_INSTANCE_INTERFACE a
444: SET a.instance_id = (SELECT b.instance_id
445: FROM csi_item_instances b
446: WHERE a.instance_number = b.instance_number)
447: WHERE a.instance_number IS NOT NULL

Line 456: UPDATE CSI_INSTANCE_INTERFACE cii

452: BEGIN
453: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
454: l_error_message := fnd_message.get;
455:
456: UPDATE CSI_INSTANCE_INTERFACE cii
457: SET error_text =l_error_message , process_status ='E'
458: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
459: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))
460: AND cii.source_system_name = p_source_system_name

Line 496: UPDATE CSI_INSTANCE_INTERFACE cii

492: BEGIN
493: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
494: l_error_message := fnd_message.get;
495:
496: UPDATE CSI_INSTANCE_INTERFACE cii
497: SET error_text =l_error_message
498: ,process_status ='E'
499: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
500: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 523: UPDATE CSI_INSTANCE_INTERFACE cii

519:
520: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
521: l_error_message := fnd_message.get;
522:
523: UPDATE CSI_INSTANCE_INTERFACE cii
524: SET error_text =l_error_message
525: ,process_status ='E'
526: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
527: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 549: UPDATE CSI_INSTANCE_INTERFACE cii

545: /* IB UI allows us to create an internally owned instance without an asset association.
546: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
547: l_error_message := fnd_message.get;
548:
549: UPDATE CSI_INSTANCE_INTERFACE cii
550: SET error_text =l_error_message
551: ,process_status ='E'
552: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)
553: OR NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,'$CSI_NULL_VALUE$'))

Line 2776: update csi_instance_interface

2772: --u_instance_tbl(inst_idx).instance_id := l_instance_id;
2773: u_instance_tbl(u_inst_idx).instance_id := l_instance_id; --Added for open
2774: -- call resolve_update_ids
2775: BEGIN
2776: update csi_instance_interface
2777: set instance_id = l_instance_id
2778: where inst_interface_id = iface_Det_rec.inst_interface_id;
2779: END;
2780:

Line 2963: UPDATE csi_instance_interface

2959: THEN
2960: SAVEPOINT s_txnmiddle;
2961: RAISE g_upd_error;
2962: ELSE
2963: UPDATE csi_instance_interface
2964: SET process_status = 'P'
2965: WHERE instance_id = u_instance_tbl(i).instance_id;
2966: END IF;
2967: END IF;

Line 3192: UPDATE csi_instance_interface

3188: WHEN g_exc_error THEN
3189: FND_File.Put_Line(Fnd_File.LOG,'error:'||l_error_message);
3190:
3191: ROLLBACK TO s_txnmiddle;
3192: UPDATE csi_instance_interface
3193: SET process_Status = 'E',
3194: error_text = l_error_message
3195: WHERE transaction_identifier = get_txns_rec.transaction_identifier
3196: AND source_system_name = p_source_system_name;