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_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_TRANSACTIONS

Line 667: csi_transactions t

663:
664: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
665: INTO l_transaction_date
666: FROM csi_i_parties_h s,
667: csi_transactions t
668: WHERE s.instance_party_id=p_instance_party_id
669: AND s.transaction_id=t.transaction_id
670: AND t.transaction_id <>nvl(p_txn_id, -99999);
671:

Line 687: csi_transactions t

683: IF C1%FOUND then
684: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
685: INTO l_transaction_date
686: FROM csi_i_parties_h s,
687: csi_transactions t
688: WHERE s.instance_party_id=l_contact_temp
689: AND s.transaction_id=t.transaction_id
690: AND t.transaction_id <> nvl(p_txn_id, -99999);
691:

Line 709: csi_transactions t

705: IF C2%FOUND then
706: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
707: INTO l_transaction_date
708: FROM csi_ip_accounts_h s,
709: csi_transactions t
710: WHERE s.ip_account_id =l_account_temp
711: AND s.transaction_id=t.transaction_id
712: AND t.transaction_id <> nvl(p_txn_id, -99999);
713:

Line 1312: csi_transactions t

1308: IF p_end_date < sysdate THEN
1309: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
1310: INTO l_transaction_date
1311: FROM csi_ip_accounts_h s,
1312: csi_transactions t
1313: WHERE s.ip_account_id=p_ip_account_id
1314: AND s.transaction_id=t.transaction_id
1315: AND t.transaction_id <> nvl(p_txn_id, -99999);
1316: