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_I_VERSION_LABELS_H

Line 4576: From CSI_I_VERSION_LABELS_H csh,

4572:
4573: Cursor ver_label_hist_csr (p_from_trans IN NUMBER,
4574: p_to_trans IN NUMBER) IS
4575: Select csh.*
4576: From CSI_I_VERSION_LABELS_H csh,
4577: CSI_TRANSACTIONS csit
4578: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
4579: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4580: And csh.transaction_id = csit.transaction_id;

Line 4593: Where object_name = 'CSI_I_VERSION_LABELS_H';

4589: Begin
4590: Select object_id
4591: Into l_table_id
4592: From csi_object_dictionary
4593: Where object_name = 'CSI_I_VERSION_LABELS_H';
4594: Exception
4595: When no_data_found Then
4596: l_table_id := 8;
4597: When others Then

Line 4926: Delete From CSI_I_VERSION_LABELS_H

4922: -- Purge the corresonding Archive data from the Instance Ver. Labels history tables
4923:
4924: FORALL i IN 1 .. l_cnt
4925:
4926: Delete From CSI_I_VERSION_LABELS_H
4927: Where version_label_history_id = l_ver_label_hist_rec_tab.version_label_history_id(i);
4928:
4929:
4930: End If; -- if l_cnt > 0

Line 6015: From CSI_I_VERSION_LABELS_H csh,

6011: --
6012: Begin
6013: Select COUNT(*)
6014: Into l_temp7
6015: From CSI_I_VERSION_LABELS_H csh,
6016: CSI_TRANSACTIONS csit
6017: Where csit.transaction_id between From_trans and To_trans
6018: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
6019: And csh.transaction_id = csit.transaction_id;