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_MASS_EDIT_PUB dependencies on CSI_IP_ACCOUNTS

Line 507: csi_ip_accounts cia,

503: cia.party_account_id pty_acc_party_account_id,
504: cia.relationship_type_code pty_acct_rel_type_code,
505: cia.object_version_number pty_acct_obj_version_number
506: FROM csi_i_parties cip,
507: csi_ip_accounts cia,
508: csi_t_txn_line_details ctld
509: WHERE cip.instance_id = ctld.instance_id
510: AND cip.contact_flag ='N'
511: AND cip.relationship_type_code = 'OWNER'

Line 539: AND NOT EXISTS (SELECT 'X' FROM csi_i_parties cip, csi_ip_accounts cia

535: AND ctld.transaction_line_id = p_txn_line_id
536: AND ctld.instance_exists_flag = 'Y'
537: AND ctld.preserve_detail_flag = 'Y'
538: AND cip.party_id in (SELECT INTERNAL_PARTY_ID FROM csi_install_parameters)
539: AND NOT EXISTS (SELECT 'X' FROM csi_i_parties cip, csi_ip_accounts cia
540: WHERE cip.INSTANCE_PARTY_ID = cia.INSTANCE_PARTY_ID
541: AND cip.instance_id = ctld.instance_id
542: AND cip.contact_flag = 'N'
543: AND cip.relationship_type_code = 'OWNER');

Line 4987: from CSI_I_PARTIES cip, csi_ip_accounts cia

4983: Select cip.INSTANCE_PARTY_ID, cip.PARTY_ID, cia.PARTY_ACCOUNT_ID, cia.IP_ACCOUNT_ID,
4984: CIP.OBJECT_VERSION_NUMBER, CIA.OBJECT_VERSION_NUMBER
4985: into l_instance_party_id, l_curr_partyid, l_curr_accountid, l_ip_account_id,
4986: l_party_obj_ver, l_act_obj_ver
4987: from CSI_I_PARTIES cip, csi_ip_accounts cia
4988: where cip.INSTANCE_PARTY_ID = cia.INSTANCE_PARTY_ID
4989: AND cip.RELATIONSHIP_TYPE_CODE = 'OWNER' AND cip.CONTACT_FLAG = 'N'
4990: AND Nvl(cip.ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE
4991: AND Nvl(cip.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE