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_I_VERSION_LABELS_H

Line 3266: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||

3262: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3263: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3264: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
3265: ' WHERE a.pricing_attribute_id = b.pricing_attribute_id and b.transaction_id = :p_transaction_id '||
3266: ' UNION SELECT a.instance_id FROM csi_i_version_labels a, csi_i_version_labels_h b '||
3267: ' WHERE a.version_label_id = b.version_label_id and b.transaction_id = :p_transaction_id '||
3268: ' UNION SELECT a.instance_id FROM csi_item_instances a, csi_systems_b b, csi_systems_h c '||
3269: ' WHERE a.system_id = b.system_id and b.system_id = c.system_id and c.transaction_id = :p_transaction_id ';
3270:

Line 10785: FROM CSI_I_VERSION_LABELS_H CIVLH, CSI_I_VERSION_LABELS CIVL

10781: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10782: UNION ALL
10783:
10784: SELECT CIVLH.TRANSACTION_ID TRANSACTION_ID, CIVL.INSTANCE_ID INSTANCE_ID
10785: FROM CSI_I_VERSION_LABELS_H CIVLH, CSI_I_VERSION_LABELS CIVL
10786: WHERE CIVLH.VERSION_LABEL_ID = CIVL.VERSION_LABEL_ID
10787: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10788: UNION ALL
10789:

Line 22474: FROM CSI_I_VERSION_LABELS_H

22470: NEW_ATTRIBUTE12 ,
22471: NEW_ATTRIBUTE13 ,
22472: NEW_ATTRIBUTE14 ,
22473: NEW_ATTRIBUTE15
22474: FROM CSI_I_VERSION_LABELS_H
22475: WHERE version_label_id = p_ver_label_id
22476: ORDER BY creation_date;
22477:
22478:

Line 22550: FROM CSI_I_VERSION_LABELS_H

22546: NEW_ATTRIBUTE12 ,
22547: NEW_ATTRIBUTE13 ,
22548: NEW_ATTRIBUTE14 ,
22549: NEW_ATTRIBUTE15
22550: FROM CSI_I_VERSION_LABELS_H
22551: WHERE version_label_history_id = p_ver_label_hist_id
22552: and full_dump_flag = 'Y' ;
22553:
22554: BEGIN

Line 22601: FROM CSI_I_VERSION_LABELS_H

22597:
22598: CURSOR get_nearest_full_dump(p_ver_label_id IN NUMBER ,p_time IN DATE) IS
22599: SELECT
22600: MAX(version_label_history_id)
22601: FROM CSI_I_VERSION_LABELS_H
22602: WHERE creation_date <= p_time
22603: and version_label_id = p_ver_label_id
22604: and full_dump_flag = 'Y' ;
22605:

Line 22652: FROM CSI_I_VERSION_LABELS_H

22648: OLD_ATTRIBUTE14 ,
22649: NEW_ATTRIBUTE14 ,
22650: OLD_ATTRIBUTE15 ,
22651: NEW_ATTRIBUTE15
22652: FROM CSI_I_VERSION_LABELS_H
22653: WHERE creation_date <= p_time
22654: and creation_date >= p_nearest_full_dump
22655: and version_label_id = p_ver_label_id
22656: ORDER BY creation_date;

Line 23236: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

23232: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23233:
23234: -- Call the table handlers to insert into history table
23235:
23236: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
23237: (
23238: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
23239: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
23240: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 23405: FROM csi_i_version_labels_h

23401: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23402:
23403: CURSOR version_hist_csr (p_version_hist_id NUMBER) IS
23404: SELECT *
23405: FROM csi_i_version_labels_h
23406: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id
23407: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23408: l_version_hist_csr version_hist_csr%ROWTYPE;
23409: l_version_hist_id NUMBER;

Line 23406: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id

23402:
23403: CURSOR version_hist_csr (p_version_hist_id NUMBER) IS
23404: SELECT *
23405: FROM csi_i_version_labels_h
23406: WHERE csi_i_version_labels_h.version_label_history_id = p_version_hist_id
23407: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
23408: l_version_hist_csr version_hist_csr%ROWTYPE;
23409: l_version_hist_id NUMBER;
23410: BEGIN

Line 23577: FROM csi_i_version_labels_h h

23573: -- Start of modification for Bug#2547034 on 09/20/02 - rtalluri
23574: BEGIN
23575: SELECT version_label_history_id
23576: INTO l_version_hist_id
23577: FROM csi_i_version_labels_h h
23578: WHERE h.transaction_id = p_txn_rec.transaction_id
23579: AND h.version_label_id = p_version_label_rec.version_label_id;
23580:
23581: OPEN version_hist_csr(l_version_hist_id);

Line 23587: CSI_I_VERSION_LABELS_H_PKG.Update_Row

23583: CLOSE version_hist_csr;
23584:
23585: IF l_version_hist_csr.full_dump_flag = 'Y'
23586: THEN
23587: CSI_I_VERSION_LABELS_H_PKG.Update_Row
23588: (
23589: p_VERSION_LABEL_HISTORY_ID => l_version_hist_id ,
23590: p_VERSION_LABEL_ID => fnd_api.g_miss_num ,
23591: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 23960: csi_i_version_labels_h_pkg.update_row

23956: l_version_hist_csr.new_attribute15 := p_version_label_rec.attribute15;
23957: END IF;
23958: --
23959:
23960: csi_i_version_labels_h_pkg.update_row
23961: (
23962: p_version_label_history_id => l_version_hist_id ,
23963: p_version_label_id => fnd_api.g_miss_num ,
23964: p_transaction_id => fnd_api.g_miss_num ,

Line 24089: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24085: END IF;
24086:
24087: -- Call the table handlers to insert into history table
24088:
24089: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24090: (
24091: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24092: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
24093: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 24360: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24356: l_ver_label_hist_rec.new_attribute15 := p_version_label_rec.attribute15 ;
24357: END IF;
24358:
24359: -- Call the table handlers to insert into history table
24360: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24361: (
24362: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24363: p_VERSION_LABEL_ID => p_version_label_rec.VERSION_LABEL_ID ,
24364: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 24690: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24686: -- changed columns have old and new values while the unchanged values have old and new values
24687: -- exactly same
24688:
24689: -- Call the table handlers to insert into history table
24690: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24691: (
24692: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24693: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id ,
24694: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 24751: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

24747: -- If the mod value is not equal to zero then dump only the changed columns
24748: -- while the unchanged values have old and new values as null
24749:
24750: -- Call the table handlers to insert into history table
24751: CSI_I_VERSION_LABELS_H_PKG.Insert_Row
24752: (
24753: px_VERSION_LABEL_HISTORY_ID => l_version_label_hist_id ,
24754: p_VERSION_LABEL_ID => p_version_label_rec.version_label_id ,
24755: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 34274: FROM csi_i_version_labels_h vlh,

34270: vlh.NEW_ATTRIBUTE15 ,
34271: vlh.FULL_DUMP_FLAG ,
34272: vlh.OBJECT_VERSION_NUMBER,
34273: vl.INSTANCE_ID
34274: FROM csi_i_version_labels_h vlh,
34275: csi_i_version_labels vl
34276: WHERE vlh.transaction_id = i_transaction_id
34277: AND vlh.version_label_id = vl.version_label_id;
34278:

Line 34627: csi_i_version_labels_h ch

34623: SELECT cv.version_label_id version_label_id
34624: ,cv.object_version_number object_version_number
34625: ,cv.instance_id instance_id
34626: FROM csi_i_version_labels cv,
34627: csi_i_version_labels_h ch
34628: WHERE cv.version_label_id=ch.version_label_id
34629: AND ch.transaction_id=p_txn_id;
34630: l_sysdate DATE :=SYSDATE;
34631: l_return_status VARCHAR2(1);