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.

[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on HZ_RELATIONSHIPS

Line 130: HZ_RELATIONSHIPS rel,

126: CURSOR csr_get_contact_name IS
127: SELECT PARTY.party_name contact_name
128: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
129: HZ_PARTIES party,
130: HZ_RELATIONSHIPS rel,
131: HZ_ORG_CONTACTS org_cont,
132: HZ_CUST_ACCOUNTS role_acct
133: WHERE acct_role.party_id = rel.party_id
134: and acct_role.role_type = 'CONTACT'