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_ITEM_INSTANCE_PVT dependencies on CSI_IEA_VALUES

Line 3258: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||

3254: ' and transaction_id = :p_transaction_id UNION '||
3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
3258: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3259: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3261: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3262: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||

Line 10742: FROM CSI_IEA_VALUES_H CIVH, CSI_IEA_VALUES CIV

10738: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10739: UNION ALL
10740:
10741: SELECT CIVH.TRANSACTION_ID TRANSACTION_ID, CIV.INSTANCE_ID INSTANCE_ID
10742: FROM CSI_IEA_VALUES_H CIVH, CSI_IEA_VALUES CIV
10743: WHERE CIV.ATTRIBUTE_VALUE_ID = CIVH.ATTRIBUTE_VALUE_ID
10744: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10745: UNION ALL
10746:

Line 24881: FROM csi_iea_values_h

24877: NEW_attribute12,
24878: NEW_attribute13,
24879: NEW_attribute14,
24880: NEW_attribute15
24881: FROM csi_iea_values_h
24882: WHERE attribute_value_id = p_ext_id
24883: ORDER BY creation_date;
24884:
24885: BEGIN

Line 24951: FROM csi_iea_values_h

24947: NEW_attribute12,
24948: NEW_attribute13,
24949: NEW_attribute14,
24950: NEW_attribute15
24951: FROM csi_iea_values_h
24952: WHERE attribute_value_history_id = p_ext_hist_id
24953: AND full_dump_flag = 'Y';
24954:
24955: BEGIN

Line 25004: FROM csi_iea_values_h

25000: Process_next EXCEPTION;
25001:
25002: CURSOR get_nearest_full_dump(p_att_val_id IN NUMBER ,p_time IN DATE) IS
25003: SELECT MAX(attribute_value_history_id)
25004: FROM csi_iea_values_h
25005: WHERE creation_date <= p_time
25006: AND attribute_value_id = p_att_val_id
25007: AND full_dump_flag = 'Y' ;
25008:

Line 25052: FROM csi_iea_values_h

25048: OLD_ATTRIBUTE14 ,
25049: NEW_ATTRIBUTE14 ,
25050: OLD_ATTRIBUTE15 ,
25051: NEW_ATTRIBUTE15
25052: FROM csi_iea_values_h
25053: WHERE creation_date <= p_time
25054: AND creation_date >= p_nearest_full_dump
25055: AND attribute_value_id = p_att_val_id
25056: ORDER BY creation_date;

Line 25636: FROM csi_iea_values

25632: SELECT attribute_value_id,
25633: object_version_number
25634: INTO p_ext_attrib_rec.attribute_value_id,
25635: p_ext_attrib_rec.object_version_number
25636: FROM csi_iea_values
25637: WHERE instance_id = p_ext_attrib_rec.instance_id
25638: AND attribute_id = p_ext_attrib_rec.attribute_id
25639: AND active_end_date < SYSDATE
25640: AND ROWNUM=1;

Line 25808: -- Create a record in csi_iea_values

25804:
25805: END IF;
25806:
25807: IF p_called_from_grp <> FND_API.G_TRUE THEN
25808: -- Create a record in csi_iea_values
25809: CSI_IEA_VALUES_PKG.Insert_Row
25810: (
25811: l_attribute_value_id
25812: ,p_ext_attrib_rec.attribute_id

Line 25809: CSI_IEA_VALUES_PKG.Insert_Row

25805: END IF;
25806:
25807: IF p_called_from_grp <> FND_API.G_TRUE THEN
25808: -- Create a record in csi_iea_values
25809: CSI_IEA_VALUES_PKG.Insert_Row
25810: (
25811: l_attribute_value_id
25812: ,p_ext_attrib_rec.attribute_id
25813: ,p_ext_attrib_rec.instance_id

Line 25878: CSI_IEA_VALUES_H_PKG.Insert_Row(

25874: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
25875:
25876: l_dump_frequency_flag :='N';
25877: -- Create a history
25878: CSI_IEA_VALUES_H_PKG.Insert_Row(
25879: l_attribute_value_h_id
25880: ,l_attribute_value_id
25881: ,p_txn_rec.transaction_id
25882: ,NULL

Line 26025: FROM csi_iea_values_h

26021: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26022:
26023: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26024: SELECT *
26025: FROM csi_iea_values_h
26026: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id
26027: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
26028: l_ieav_hist_id NUMBER;
26029: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;

Line 26026: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id

26022:
26023: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26024: SELECT *
26025: FROM csi_iea_values_h
26026: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id
26027: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
26028: l_ieav_hist_id NUMBER;
26029: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;
26030:

Line 26169: CSI_IEA_VALUES_PKG.Update_Row

26165: -- Get the new object version number
26166: l_ext_attrib_rec.object_version_number :=
26167: csi_extend_attrib_vld_pvt.get_object_version_number(l_ext_attrib_rec.object_version_number);
26168:
26169: CSI_IEA_VALUES_PKG.Update_Row
26170: (
26171: l_attribute_value_id
26172: ,p_ext_attrib_rec.attribute_id
26173: ,p_ext_attrib_rec.instance_id

Line 26250: FROM csi_iea_values_h h

26246: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
26247: BEGIN
26248: SELECT attribute_value_history_id
26249: INTO l_ieav_hist_id
26250: FROM csi_iea_values_h h
26251: WHERE h.transaction_id = p_txn_rec.transaction_id
26252: AND h.attribute_value_id = p_ext_attrib_rec.attribute_value_id;
26253:
26254: OPEN ieav_hist_csr(l_ieav_hist_id);

Line 26260: csi_iea_values_h_pkg.update_row (

26256: CLOSE ieav_hist_csr;
26257:
26258: IF l_ieav_hist_csr.full_dump_flag = 'Y'
26259: THEN
26260: csi_iea_values_h_pkg.update_row (
26261: p_attribute_value_history_id => l_ieav_hist_id ,
26262: p_attribute_value_id => fnd_api.g_miss_num ,
26263: p_transaction_id => fnd_api.g_miss_num ,
26264: p_old_attribute_value => fnd_api.g_miss_char ,

Line 26598: csi_iea_values_h_pkg.update_row (

26594: l_ieav_hist_csr.new_attribute15 := l_temp_ext_attrib_rec.attribute15;
26595: END IF;
26596: --
26597:
26598: csi_iea_values_h_pkg.update_row (
26599: p_attribute_value_history_id => l_ieav_hist_id ,
26600: p_attribute_value_id => fnd_api.g_miss_num ,
26601: p_transaction_id => fnd_api.g_miss_num ,
26602: p_old_attribute_value => l_ieav_hist_csr.old_attribute_value ,

Line 26724: CSI_IEA_VALUES_H_PKG.Insert_Row(

26720: l_temp_ext_attrib_rec.ATTRIBUTE15 := l_ext_attrib_rec.ATTRIBUTE15;
26721: END IF;
26722:
26723: -- Create a history
26724: CSI_IEA_VALUES_H_PKG.Insert_Row(
26725: l_attribute_value_h_id
26726: ,l_attribute_value_id
26727: ,p_txn_rec.transaction_id
26728: ,l_ext_attrib_rec.attribute_value

Line 26972: CSI_IEA_VALUES_H_PKG.Insert_Row(

26968: l_ext_att_hist_rec.new_attribute15 := p_ext_attrib_rec.attribute15 ;
26969: END IF;
26970:
26971: -- Create a history
26972: CSI_IEA_VALUES_H_PKG.Insert_Row(
26973: l_attribute_value_h_id
26974: ,l_attribute_value_id
26975: ,p_txn_rec.transaction_id
26976: ,l_ext_att_hist_rec.old_attribute_value

Line 31741: FROM csi_iea_values_h ieh,

31737: ieh.FULL_DUMP_FLAG ,
31738: ieh.OBJECT_VERSION_NUMBER ,
31739: ie.INSTANCE_ID ,
31740: iea.attribute_code
31741: FROM csi_iea_values_h ieh,
31742: csi_iea_values ie ,
31743: csi_i_extended_attribs iea
31744: WHERE ieh.transaction_id = p_txn_id
31745: AND ieh.attribute_value_id = ie.attribute_value_id

Line 31742: csi_iea_values ie ,

31738: ieh.OBJECT_VERSION_NUMBER ,
31739: ie.INSTANCE_ID ,
31740: iea.attribute_code
31741: FROM csi_iea_values_h ieh,
31742: csi_iea_values ie ,
31743: csi_i_extended_attribs iea
31744: WHERE ieh.transaction_id = p_txn_id
31745: AND ieh.attribute_value_id = ie.attribute_value_id
31746: AND ie.attribute_id= iea.attribute_id;