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_TRANSACTIONS

Line 70: From CSI_TRANSACTIONS

66: Select Min(transaction_id),
67: Max(transaction_id)
68: Into from_trans,
69: to_trans
70: From CSI_TRANSACTIONS
71: Where creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS');
72: Exception
73: When Others Then
74: Null;

Line 111: -- srramakr Bug 4366231. The following routine joins each entity history table with CSI_TRANSACTIONS

107: when no_data_found then
108: null;
109: End;
110: --
111: -- srramakr Bug 4366231. The following routine joins each entity history table with CSI_TRANSACTIONS
112: -- to get the count of records purged and archieved. This causes lot of performance issue. Giving such
113: -- count is unnecessary. The user can always check against the archive table. Hence commenting it.
114: /* csi_txn_history_purge_pvt.Record_count(From_trans => From_trans,
115: To_trans => To_trans,

Line 468: CSI_TRANSACTIONS csit

464: Cursor inst_hist_csr (p_from_trans IN NUMBER,
465: p_to_trans IN NUMBER) IS
466: Select csh.*
467: From CSI_ITEM_INSTANCES_H csh,
468: CSI_TRANSACTIONS csit
469: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
470: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
471: And csh.transaction_id = csit.transaction_id;
472:

Line 1410: CSI_TRANSACTIONS csit

1406: Cursor pty_hist_csr (p_from_trans IN NUMBER,
1407: p_to_trans IN NUMBER) IS
1408: Select csh.*
1409: From CSI_I_PARTIES_H csh,
1410: CSI_TRANSACTIONS csit
1411: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
1412: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1413: And csh.transaction_id = csit.transaction_id;
1414:

Line 1853: CSI_TRANSACTIONS csit

1849: Cursor acct_hist_csr (p_from_trans IN NUMBER,
1850: p_to_trans IN NUMBER) IS
1851: Select csh.*
1852: From CSI_IP_ACCOUNTS_H csh,
1853: CSI_TRANSACTIONS csit
1854: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
1855: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1856: And csh.transaction_id = csit.transaction_id;
1857:

Line 2280: CSI_TRANSACTIONS csit

2276: Cursor org_units_hist_csr (p_from_trans IN NUMBER,
2277: p_to_trans IN NUMBER) IS
2278: Select csh.*
2279: From CSI_I_ORG_ASSIGNMENTS_H csh,
2280: CSI_TRANSACTIONS csit
2281: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
2282: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2283: And csh.transaction_id = csit.transaction_id;
2284:

Line 2683: CSI_TRANSACTIONS csit

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 p_from_trans and p_to_trans --Bug 8836533
2685: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2686: And csh.transaction_id = csit.transaction_id;
2687:

Line 3079: CSI_TRANSACTIONS csit

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 p_from_trans and p_to_trans --Bug 8836533
3081: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
3082: And csh.transaction_id = csit.transaction_id;
3083:

Line 4274: CSI_TRANSACTIONS csit

4270: Cursor ins_asset_hist_csr (p_from_trans IN NUMBER,
4271: p_to_trans IN NUMBER) IS
4272: Select csh.*
4273: From CSI_I_ASSETS_H csh,
4274: CSI_TRANSACTIONS csit
4275: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
4276: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4277: And csh.transaction_id = csit.transaction_id;
4278:

Line 4577: CSI_TRANSACTIONS csit

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;
4581:

Line 4989: CSI_TRANSACTIONS csit

4985: Cursor rel_hist_csr (p_from_trans IN NUMBER,
4986: p_to_trans IN NUMBER) IS
4987: Select csh.*
4988: From CSI_II_RELATIONSHIPS_H csh,
4989: CSI_TRANSACTIONS csit
4990: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
4991: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4992: And csh.transaction_id = csit.transaction_id;
4993:

Line 5400: CSI_TRANSACTIONS csit

5396: Cursor sys_hist_csr (p_from_trans IN NUMBER,
5397: p_to_trans IN NUMBER) IS
5398: Select csh.*
5399: From CSI_SYSTEMS_H csh,
5400: CSI_TRANSACTIONS csit
5401: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
5402: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5403: And csh.transaction_id = csit.transaction_id;
5404:

Line 5918: CSI_TRANSACTIONS csit

5914: Begin
5915: Select COUNT(*)
5916: Into l_temp
5917: From CSI_ITEM_INSTANCES_H csh,
5918: CSI_TRANSACTIONS csit
5919: Where csit.transaction_id between From_trans and To_trans
5920: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5921: And csh.transaction_id = csit.transaction_id;
5922: Exception

Line 5932: CSI_TRANSACTIONS csit

5928: Begin
5929: Select COUNT(*)
5930: Into l_temp1
5931: From CSI_I_PARTIES_H csh,
5932: CSI_TRANSACTIONS csit
5933: Where csit.transaction_id between From_trans and To_trans
5934: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5935: And csh.transaction_id = csit.transaction_id;
5936: Exception

Line 5946: CSI_TRANSACTIONS csit

5942: Begin
5943: Select COUNT(*)
5944: Into l_temp2
5945: From CSI_IP_ACCOUNTS_H csh,
5946: CSI_TRANSACTIONS csit
5947: Where csit.transaction_id between From_trans and To_trans
5948: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5949: And csh.transaction_id = csit.transaction_id;
5950: Exception

Line 5960: CSI_TRANSACTIONS csit

5956: Begin
5957: Select COUNT(*)
5958: Into l_temp3
5959: From CSI_I_ORG_ASSIGNMENTS_H csh,
5960: CSI_TRANSACTIONS csit
5961: Where csit.transaction_id between From_trans and To_trans
5962: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5963: And csh.transaction_id = csit.transaction_id;
5964: Exception

Line 5974: CSI_TRANSACTIONS csit

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;
5978: Exception

Line 5988: CSI_TRANSACTIONS csit

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;
5992: Exception

Line 6002: CSI_TRANSACTIONS csit

5998: Begin
5999: Select COUNT(*)
6000: Into l_temp6
6001: From CSI_I_ASSETS_H csh,
6002: CSI_TRANSACTIONS csit
6003: Where csit.transaction_id between From_trans and To_trans
6004: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
6005: And csh.transaction_id = csit.transaction_id;
6006: Exception

Line 6016: CSI_TRANSACTIONS csit

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;
6020: Exception

Line 6030: CSI_TRANSACTIONS csit

6026: Begin
6027: Select COUNT(*)
6028: Into l_temp8
6029: From CSI_II_RELATIONSHIPS_H csh,
6030: CSI_TRANSACTIONS csit
6031: Where csit.transaction_id between From_trans and To_trans
6032: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
6033: And csh.transaction_id = csit.transaction_id;
6034: Exception

Line 6044: CSI_TRANSACTIONS csit

6040: Begin
6041: Select COUNT(*)
6042: Into l_temp9
6043: From CSI_SYSTEMS_H csh,
6044: CSI_TRANSACTIONS csit
6045: Where csit.transaction_id between From_trans and To_trans
6046: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
6047: And csh.transaction_id = csit.transaction_id;
6048: Exception