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.OE_CREATE_ACCOUNT_INFO dependencies on HZ_ORG_CONTACTS

Line 2923: FROM hz_org_contacts org,

2919: CURSOR c_org_contact(in_org_contact_id in number,
2920: in_cust_account_id in number) IS
2921: SELECT role.cust_account_role_id,
2922: role.cust_acct_site_id
2923: FROM hz_org_contacts org,
2924: hz_relationships rel,
2925: hz_cust_accounts acct,
2926: hz_cust_account_roles role
2927: WHERE org.org_Contact_id = in_org_contact_id

Line 2949: FROM hz_org_contacts org,

2945: and status = 'A';
2946:
2947: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
2948: SELECT rel.party_id
2949: FROM hz_org_contacts org,
2950: hz_relationships rel
2951: WHERE org.org_contact_id = in_org_contact_id
2952: AND rel.status = 'A'
2953: AND rel.relationship_id = org.party_relationship_id

Line 5742: hz_org_contacts org_contact,

5738: IS
5739: SELECT org_contact.org_contact_id
5740: FROM hz_parties party,
5741: hz_relationships rel,
5742: hz_org_contacts org_contact,
5743: ar_lookups arl
5744: WHERE rel.object_id=in_party_id
5745: AND rel.relationship_id=org_contact.party_relationship_id
5746: AND rel.party_id=rel.subject_id