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.PVX_MISC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 2115: from hz_cust_accounts hzca

2111: and hzp.party_id = pvpp.partner_party_id
2112: and hzp.status = 'A'
2113: and not exists
2114: (select 1
2115: from hz_cust_accounts hzca
2116: where hzca.status = 'A'
2117: and hzca.party_id = pvpp.partner_party_id);
2118:
2119: CURSOR c_get_prtnrcntct_wo_role IS

Line 2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca

2117: and hzca.party_id = pvpp.partner_party_id);
2118:
2119: CURSOR c_get_prtnrcntct_wo_role IS
2120: select hzr.party_id, max(hzca.cust_account_id) cust_account_id
2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca
2122: where jtfre.category= 'PARTY'
2123: and jtfre.user_id is not null
2124: and jtfre.source_id = hzr.party_id
2125: and hzr.object_id in (select pvpp.partner_party_id

Line 2138: where hzcar.cust_account_id IN (select cust_account_id from hz_cust_accounts where party_id = hzr.object_id)

2134: and nvl(hzr.end_date,sysdate) >= sysdate
2135: and not exists
2136: ( select 1
2137: from hz_cust_account_roles hzcar
2138: where hzcar.cust_account_id IN (select cust_account_id from hz_cust_accounts where party_id = hzr.object_id)
2139: and nvl(hzcar.status,'A')='A'
2140: and nvl(hzcar.begin_date,sysdate) <= sysdate
2141: and nvl(hzcar.end_date,sysdate) >= sysdate
2142: and hzr.party_id = hzcar.party_id