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_PRICING_ATTRIBS_H

Line 3078: From CSI_I_PRICING_ATTRIBS_H csh,

3074:
3075: Cursor pri_attribs_hist_csr (p_from_trans IN NUMBER,
3076: p_to_trans IN NUMBER) IS
3077: Select csh.*
3078: From CSI_I_PRICING_ATTRIBS_H csh,
3079: CSI_TRANSACTIONS csit
3080: Where csit.transaction_id between from_trans and to_trans
3081: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
3082: And csh.transaction_id = csit.transaction_id;

Line 3095: Where object_name = 'CSI_I_PRICING_ATTRIBS_H';

3091: Begin
3092: Select object_id
3093: Into l_table_id
3094: From csi_object_dictionary
3095: Where object_name = 'CSI_I_PRICING_ATTRIBS_H';
3096: Exception
3097: When no_data_found Then
3098: l_table_id := 6;
3099: When others Then

Line 4212: Delete From CSI_I_PRICING_ATTRIBS_H

4208: -- Purge the corresonding Archive data from the Instance history tables
4209:
4210: FORALL i IN 1 .. l_cnt
4211:
4212: Delete From CSI_I_PRICING_ATTRIBS_H
4213: Where price_attrib_history_id = l_pri_attribs_hist_rec_tab.price_attrib_history_id(i);
4214:
4215:
4216: End If; -- if l_cnt > 0

Line 5987: From CSI_I_PRICING_ATTRIBS_H csh,

5983: --
5984: Begin
5985: Select COUNT(*)
5986: Into l_temp5
5987: From CSI_I_PRICING_ATTRIBS_H csh,
5988: CSI_TRANSACTIONS csit
5989: Where csit.transaction_id between From_trans and To_trans
5990: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5991: And csh.transaction_id = csit.transaction_id;