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.ONT_ITM_PKG dependencies on HZ_PARTIES

Line 143: HZ_PARTIES PARTY,

139:
140: SELECT PARTY.PARTY_NAME, party.party_id, party.party_number
141: INTO x_contact_name, x_contact_hz_id, x_contact_number --Bug 9583024
142: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
143: HZ_PARTIES PARTY,
144: HZ_CUST_ACCOUNTS ACCT,
145: HZ_RELATIONSHIPS REL,
146: HZ_PARTIES REL_PARTY
147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id

Line 146: HZ_PARTIES REL_PARTY

142: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
143: HZ_PARTIES PARTY,
144: HZ_CUST_ACCOUNTS ACCT,
145: HZ_RELATIONSHIPS REL,
146: HZ_PARTIES REL_PARTY
147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
148: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
149: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
150: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 150: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

146: HZ_PARTIES REL_PARTY
147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
148: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
149: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
150: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
151: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
152: AND REL.SUBJECT_ID = PARTY.PARTY_ID
153: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
154: AND REL.OBJECT_ID = ACCT.PARTY_ID

Line 151: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
148: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
149: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
150: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
151: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
152: AND REL.SUBJECT_ID = PARTY.PARTY_ID
153: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
154: AND REL.OBJECT_ID = ACCT.PARTY_ID
155: AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID;

Line 274: hz_parties party,

270: hz_cust_acct_sites_all acct_site,
271: hz_party_sites party_site,
272: hz_locations loc,
273: hz_cust_accounts cust_acct,
274: hz_parties party,
275: hz_Person_profiles hp
276: WHERE
277: site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
278: AND acct_site.cust_account_id = cust_acct.cust_account_id

Line 337: hz_parties party,

333: party.party_id hz_party_id , -- Bug 9583024
334: party.party_number hz_party_number , -- Bug 9583024
335: party_site.party_site_number party_site_number -- Bug 9583024
336: FROM
337: hz_parties party,
338: hz_cust_accounts cust_acct,
339: hz_locations loc,
340: hz_party_sites party_site,
341: hz_Person_profiles hp

Line 351: l_contact_name HZ_PARTIES.PARTY_NAME%TYPE;

347: AND hp.party_id(+) = party.party_id -- bug 4231894
348: AND rownum = 1;
349:
350: --Added for Bug 9583024
351: l_contact_name HZ_PARTIES.PARTY_NAME%TYPE;
352: l_contact_hz_id HZ_PARTIES.PARTY_ID%TYPE;
353: l_contact_number HZ_PARTIES.PARTY_NUMBER%TYPE;
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 352: l_contact_hz_id HZ_PARTIES.PARTY_ID%TYPE;

348: AND rownum = 1;
349:
350: --Added for Bug 9583024
351: l_contact_name HZ_PARTIES.PARTY_NAME%TYPE;
352: l_contact_hz_id HZ_PARTIES.PARTY_ID%TYPE;
353: l_contact_number HZ_PARTIES.PARTY_NUMBER%TYPE;
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --

Line 353: l_contact_number HZ_PARTIES.PARTY_NUMBER%TYPE;

349:
350: --Added for Bug 9583024
351: l_contact_name HZ_PARTIES.PARTY_NAME%TYPE;
352: l_contact_hz_id HZ_PARTIES.PARTY_ID%TYPE;
353: l_contact_number HZ_PARTIES.PARTY_NUMBER%TYPE;
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: BEGIN

Line 711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;

707: l_order_line_number VARCHAR2(100); --Bug 5647666
708: l_sold_to_site_use_id NUMBER; --Bug 7261101
709: l_org_id_passed VARCHAR2(1) := 'N'; -- Bug 9130718
710: -- Added for Bug 9583024
711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

Line 712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

708: l_sold_to_site_use_id NUMBER; --Bug 7261101
709: l_org_id_passed VARCHAR2(1) := 'N'; -- Bug 9130718
710: -- Added for Bug 9583024
711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
716: l_itm_intg_gtm VARCHAR2(1) := 'N';

Line 714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;

710: -- Added for Bug 9583024
711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
716: l_itm_intg_gtm VARCHAR2(1) := 'N';
717:
718: BEGIN

Line 715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

711: x_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
712: x_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
713: x_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
714: x_contact_hz_party_id HZ_PARTIES.PARTY_ID%TYPE;
715: x_contact_hz_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
716: l_itm_intg_gtm VARCHAR2(1) := 'N';
717:
718: BEGIN
719: