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

Line 435: FROM HZ_CUST_ACCOUNTS CustAcct,

431: SELECT CustAcct.cust_account_id,
432: CustAcct.account_number,
433: CustAcct.party_id,
434: Party.party_type
435: FROM HZ_CUST_ACCOUNTS CustAcct,
436: HZ_PARTIES Party
437: WHERE CustAcct.cust_account_id = p_customer_id
438: AND CustAcct.party_id = Party.party_id;
439:

Line 965: SELECT party_id INTO l_party_id FROM hz_cust_accounts WHERE cust_account_id = p_customer_id;

961: where user_id = p_user_id;
962:
963: ELSE
964: -- Bug 5219389 - Party Id should be passed instead of cust_account_id.
965: SELECT party_id INTO l_party_id FROM hz_cust_accounts WHERE cust_account_id = p_customer_id;
966:
967: select party_id into l_party_rel_id
968: from (
969: select hr1.party_id

Line 1024: from hz_cust_accounts

1020: l_acct_number varchar2(30);
1021: BEGIN
1022: select account_number
1023: into l_acct_number
1024: from hz_cust_accounts
1025: where cust_account_id = p_cust_account_id;
1026:
1027: RETURN l_acct_number;
1028:

Line 1253: from hz_cust_accounts

1249: BEGIN
1250:
1251: select party_id
1252: into l_org_party_id
1253: from hz_cust_accounts
1254: where cust_account_id = p_customer_id;
1255:
1256: return l_org_party_id;
1257:

Line 3691: FROM HZ_CUST_ACCOUNTS CustAcct,

3687: CustAcct.account_number,
3688: CustAcct.party_id,
3689: Party.party_type,
3690: CustTrxn.org_id
3691: FROM HZ_CUST_ACCOUNTS CustAcct,
3692: RA_CUSTOMER_TRX_ALL CustTrxn,
3693: HZ_PARTIES Party
3694: WHERE CustTrxn.trx_number = p_access_domain_search_number
3695: AND CustTrxn.bill_to_customer_id = CustAcct.cust_account_id