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.AMS_ACTMETRICS_SEED_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2941: AND exists (select 1 from hz_cust_account_roles roles

2937: ams_act_products aprod
2938: where csch_parties.primary_party_id = account.party_id
2939: AND H.sold_to_org_id = account.cust_account_id
2940: AND ((source_category = 'B2B'
2941: AND exists (select 1 from hz_cust_account_roles roles
2942: where H.sold_to_contact_id = roles.cust_account_role_id
2943: AND roles.cust_account_id = account.cust_account_id
2944: AND roles.party_id = csch_parties.contact_rel_party_id
2945: AND rownum = 1))

Line 3086: AND exists (select 1 from hz_cust_account_roles roles

3082: ams_act_products aprod
3083: where csch_parties.primary_party_id = account.party_id
3084: AND H.sold_to_org_id = account.cust_account_id
3085: AND ((source_category = 'B2B'
3086: AND exists (select 1 from hz_cust_account_roles roles
3087: where H.sold_to_contact_id = roles.cust_account_role_id
3088: AND roles.cust_account_id = account.cust_account_id
3089: AND roles.party_id = csch_parties.contact_rel_party_id
3090: AND rownum = 1))

Line 3420: AND exists (select 1 from hz_cust_account_roles roles

3416: oe_order_lines_all I
3417: where csch_parties.primary_party_id = account.party_id
3418: AND H.sold_to_org_id = account.cust_account_id
3419: AND ((source_category = 'B2B'
3420: AND exists (select 1 from hz_cust_account_roles roles
3421: where H.sold_to_contact_id = roles.cust_account_role_id
3422: AND roles.cust_account_id = account.cust_account_id
3423: AND roles.party_id = csch_parties.contact_rel_party_id
3424: AND rownum = 1))