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_TXN_HISTORY_PURGE_PVT dependencies on CSI_IEA_VALUES_H

Line 2682: From CSI_IEA_VALUES_H csh,

2678:
2679: Cursor ext_attrib_hist_csr (p_from_trans IN NUMBER,
2680: p_to_trans IN NUMBER) IS
2681: Select csh.*
2682: From CSI_IEA_VALUES_H csh,
2683: CSI_TRANSACTIONS csit
2684: Where csit.transaction_id between from_trans and to_trans
2685: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2686: And csh.transaction_id = csit.transaction_id;

Line 2699: Where object_name = 'CSI_IEA_VALUES_H';

2695: Begin
2696: Select object_id
2697: Into l_table_id
2698: From csi_object_dictionary
2699: Where object_name = 'CSI_IEA_VALUES_H';
2700: Exception
2701: When no_data_found Then
2702: l_table_id := 5;
2703: When others Then

Line 3017: Delete From CSI_IEA_VALUES_H

3013: -- Purge the corresonding Archive data from the Instance history tables
3014:
3015: FORALL i IN 1 .. l_cnt
3016:
3017: Delete From CSI_IEA_VALUES_H
3018: Where attribute_value_history_id = l_ext_attrib_hist_rec_tab.attribute_value_history_id(i);
3019:
3020: End If; -- if l_cnt > 0
3021: --

Line 5973: From CSI_IEA_VALUES_H csh,

5969: --
5970: Begin
5971: Select COUNT(*)
5972: Into l_temp4
5973: From CSI_IEA_VALUES_H csh,
5974: CSI_TRANSACTIONS csit
5975: Where csit.transaction_id between From_trans and To_trans
5976: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5977: And csh.transaction_id = csit.transaction_id;