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 3277: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||

3273: ' and transaction_id = :p_transaction_id UNION '||
3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3276: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
3277: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3278: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3279: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3280: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||

Line 10993: FROM CSI_IEA_VALUES_H CIVH, CSI_IEA_VALUES CIV

10989: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10990: UNION ALL
10991:
10992: SELECT CIVH.TRANSACTION_ID TRANSACTION_ID, CIV.INSTANCE_ID INSTANCE_ID
10993: FROM CSI_IEA_VALUES_H CIVH, CSI_IEA_VALUES CIV
10994: WHERE CIV.ATTRIBUTE_VALUE_ID = CIVH.ATTRIBUTE_VALUE_ID
10995: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10996: UNION ALL
10997:

Line 25446: FROM csi_iea_values_h

25442: NEW_attribute12,
25443: NEW_attribute13,
25444: NEW_attribute14,
25445: NEW_attribute15
25446: FROM csi_iea_values_h
25447: WHERE attribute_value_id = p_ext_id
25448: ORDER BY creation_date;
25449:
25450: BEGIN

Line 25516: FROM csi_iea_values_h

25512: NEW_attribute12,
25513: NEW_attribute13,
25514: NEW_attribute14,
25515: NEW_attribute15
25516: FROM csi_iea_values_h
25517: WHERE attribute_value_history_id = p_ext_hist_id
25518: AND full_dump_flag = 'Y';
25519:
25520: BEGIN

Line 25569: FROM csi_iea_values_h

25565: Process_next EXCEPTION;
25566:
25567: CURSOR get_nearest_full_dump(p_att_val_id IN NUMBER ,p_time IN DATE) IS
25568: SELECT MAX(attribute_value_history_id)
25569: FROM csi_iea_values_h
25570: WHERE creation_date <= p_time
25571: AND attribute_value_id = p_att_val_id
25572: AND full_dump_flag = 'Y' ;
25573:

Line 25617: FROM csi_iea_values_h

25613: OLD_ATTRIBUTE14 ,
25614: NEW_ATTRIBUTE14 ,
25615: OLD_ATTRIBUTE15 ,
25616: NEW_ATTRIBUTE15
25617: FROM csi_iea_values_h
25618: WHERE creation_date <= p_time
25619: AND creation_date >= p_nearest_full_dump
25620: AND attribute_value_id = p_att_val_id
25621: ORDER BY creation_date;

Line 26201: FROM csi_iea_values

26197: SELECT attribute_value_id,
26198: object_version_number
26199: INTO p_ext_attrib_rec.attribute_value_id,
26200: p_ext_attrib_rec.object_version_number
26201: FROM csi_iea_values
26202: WHERE instance_id = p_ext_attrib_rec.instance_id
26203: AND attribute_id = p_ext_attrib_rec.attribute_id
26204: AND active_end_date < SYSDATE
26205: AND ROWNUM=1;

Line 26373: -- Create a record in csi_iea_values

26369:
26370: END IF;
26371:
26372: IF p_called_from_grp <> FND_API.G_TRUE THEN
26373: -- Create a record in csi_iea_values
26374: CSI_IEA_VALUES_PKG.Insert_Row
26375: (
26376: l_attribute_value_id
26377: ,p_ext_attrib_rec.attribute_id

Line 26374: CSI_IEA_VALUES_PKG.Insert_Row

26370: END IF;
26371:
26372: IF p_called_from_grp <> FND_API.G_TRUE THEN
26373: -- Create a record in csi_iea_values
26374: CSI_IEA_VALUES_PKG.Insert_Row
26375: (
26376: l_attribute_value_id
26377: ,p_ext_attrib_rec.attribute_id
26378: ,p_ext_attrib_rec.instance_id

Line 26443: CSI_IEA_VALUES_H_PKG.Insert_Row(

26439: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
26440:
26441: l_dump_frequency_flag :='N';
26442: -- Create a history
26443: CSI_IEA_VALUES_H_PKG.Insert_Row(
26444: l_attribute_value_h_id
26445: ,l_attribute_value_id
26446: ,p_txn_rec.transaction_id
26447: ,NULL

Line 26594: FROM csi_iea_values_h

26590: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26591:
26592: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26593: SELECT *
26594: FROM csi_iea_values_h
26595: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id
26596: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
26597: l_ieav_hist_id NUMBER;
26598: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;

Line 26595: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id

26591:
26592: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26593: SELECT *
26594: FROM csi_iea_values_h
26595: WHERE csi_iea_values_h.attribute_value_history_id = p_ieav_hist_id
26596: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
26597: l_ieav_hist_id NUMBER;
26598: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;
26599:

Line 26738: CSI_IEA_VALUES_PKG.Update_Row

26734: -- Get the new object version number
26735: l_ext_attrib_rec.object_version_number :=
26736: csi_extend_attrib_vld_pvt.get_object_version_number(l_ext_attrib_rec.object_version_number);
26737:
26738: CSI_IEA_VALUES_PKG.Update_Row
26739: (
26740: l_attribute_value_id
26741: ,p_ext_attrib_rec.attribute_id
26742: ,p_ext_attrib_rec.instance_id

Line 26819: FROM csi_iea_values_h h

26815: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
26816: BEGIN
26817: SELECT attribute_value_history_id
26818: INTO l_ieav_hist_id
26819: FROM csi_iea_values_h h
26820: WHERE h.transaction_id = p_txn_rec.transaction_id
26821: AND h.attribute_value_id = p_ext_attrib_rec.attribute_value_id;
26822:
26823: OPEN ieav_hist_csr(l_ieav_hist_id);

Line 26829: csi_iea_values_h_pkg.update_row (

26825: CLOSE ieav_hist_csr;
26826:
26827: IF l_ieav_hist_csr.full_dump_flag = 'Y'
26828: THEN
26829: csi_iea_values_h_pkg.update_row (
26830: p_attribute_value_history_id => l_ieav_hist_id ,
26831: p_attribute_value_id => fnd_api.g_miss_num ,
26832: p_transaction_id => fnd_api.g_miss_num ,
26833: p_old_attribute_value => fnd_api.g_miss_char ,

Line 27167: csi_iea_values_h_pkg.update_row (

27163: l_ieav_hist_csr.new_attribute15 := l_temp_ext_attrib_rec.attribute15;
27164: END IF;
27165: --
27166:
27167: csi_iea_values_h_pkg.update_row (
27168: p_attribute_value_history_id => l_ieav_hist_id ,
27169: p_attribute_value_id => fnd_api.g_miss_num ,
27170: p_transaction_id => fnd_api.g_miss_num ,
27171: p_old_attribute_value => l_ieav_hist_csr.old_attribute_value ,

Line 27293: CSI_IEA_VALUES_H_PKG.Insert_Row(

27289: l_temp_ext_attrib_rec.ATTRIBUTE15 := l_ext_attrib_rec.ATTRIBUTE15;
27290: END IF;
27291:
27292: -- Create a history
27293: CSI_IEA_VALUES_H_PKG.Insert_Row(
27294: l_attribute_value_h_id
27295: ,l_attribute_value_id
27296: ,p_txn_rec.transaction_id
27297: ,l_ext_attrib_rec.attribute_value

Line 27541: CSI_IEA_VALUES_H_PKG.Insert_Row(

27537: l_ext_att_hist_rec.new_attribute15 := p_ext_attrib_rec.attribute15 ;
27538: END IF;
27539:
27540: -- Create a history
27541: CSI_IEA_VALUES_H_PKG.Insert_Row(
27542: l_attribute_value_h_id
27543: ,l_attribute_value_id
27544: ,p_txn_rec.transaction_id
27545: ,l_ext_att_hist_rec.old_attribute_value

Line 32359: FROM csi_iea_values_h ieh,

32355: ieh.FULL_DUMP_FLAG ,
32356: ieh.OBJECT_VERSION_NUMBER ,
32357: ie.INSTANCE_ID ,
32358: iea.attribute_code
32359: FROM csi_iea_values_h ieh,
32360: csi_iea_values ie ,
32361: csi_i_extended_attribs iea
32362: WHERE ieh.transaction_id = p_txn_id
32363: AND ieh.attribute_value_id = ie.attribute_value_id

Line 32360: csi_iea_values ie ,

32356: ieh.OBJECT_VERSION_NUMBER ,
32357: ie.INSTANCE_ID ,
32358: iea.attribute_code
32359: FROM csi_iea_values_h ieh,
32360: csi_iea_values ie ,
32361: csi_i_extended_attribs iea
32362: WHERE ieh.transaction_id = p_txn_id
32363: AND ieh.attribute_value_id = ie.attribute_value_id
32364: AND ie.attribute_id= iea.attribute_id;