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

Line 584: FROM oe_order_headers_all o, hz_cust_accounts a

580: PROCEDURE getDtlsFromOrderNum IS
581:
582: CURSOR C_getDtlsFromOrderNum(x_OrderNum number ) IS
583: SELECT o.header_id, a.party_id
584: FROM oe_order_headers_all o, hz_cust_accounts a
585: where o.order_number = x_OrderNum
586: and a.cust_account_id = o.sold_to_org_id;
587: BEGIN
588:

Line 766: FROM hz_cust_accounts hza, hz_parties hzp

762: PROCEDURE GetDtlsFromAccountNum IS
763:
764: CURSOR C_GetCustId(x_account_num VARCHAR2) IS
765: SELECT hzp.party_id, hza.cust_account_id, hzp.party_type
766: FROM hz_cust_accounts hza, hz_parties hzp
767: --SELECT hza.party_id, hza.cust_account_id
768: --FROM hz_cust_accounts hza
769: WHERE hza.account_number = x_account_num and
770: hza.party_id = hzp.party_id;

Line 768: --FROM hz_cust_accounts hza

764: CURSOR C_GetCustId(x_account_num VARCHAR2) IS
765: SELECT hzp.party_id, hza.cust_account_id, hzp.party_type
766: FROM hz_cust_accounts hza, hz_parties hzp
767: --SELECT hza.party_id, hza.cust_account_id
768: --FROM hz_cust_accounts hza
769: WHERE hza.account_number = x_account_num and
770: hza.party_id = hzp.party_id;
771:
772: CURSOR C_GetAccountRoles (x_account_num VARCHAR2) is

Line 774: from hz_cust_accounts a, hz_cust_account_roles ar

770: hza.party_id = hzp.party_id;
771:
772: CURSOR C_GetAccountRoles (x_account_num VARCHAR2) is
773: select a.cust_account_id
774: from hz_cust_accounts a, hz_cust_account_roles ar
775: where a.account_number = x_account_num
776: and a.cust_account_id = ar.cust_account_id;
777:
778: BEGIN