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

Line 116: HZ_CUST_ACCOUNTS ROLE_ACCT

112: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
113: HZ_PARTIES PARTY,
114: HZ_RELATIONSHIPS REL,
115: HZ_ORG_CONTACTS ORG_CONT,
116: HZ_CUST_ACCOUNTS ROLE_ACCT
117: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
120: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 133: HZ_CUST_ACCOUNTS ROLE_ACCT

129: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
130: HZ_PARTIES PARTY,
131: HZ_RELATIONSHIPS REL,
132: HZ_ORG_CONTACTS ORG_CONT,
133: HZ_CUST_ACCOUNTS ROLE_ACCT
134: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
135: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
136: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
137: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 340: select party_id into customer_party_id from hz_cust_accounts where

336: --
337: -- Create an Org Contact
338: --
339: --Check for select and customer_party_id hdshah
340: select party_id into customer_party_id from hz_cust_accounts where
341: cust_account_id = x_customer_id;
342:
343: ocon_rec.party_rel_rec.subject_id := i_subject_party_id;
344: ocon_rec.party_rel_rec.object_id := customer_party_id;