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

Line 152: FROM hz_cust_accounts

148: IS
149: BEGIN
150: SELECT cust_account_id
151: INTO x_cust_account_id
152: FROM hz_cust_accounts
153: WHERE party_id = p_customer_attr_value;
154: EXCEPTION
155: WHEN OTHERS THEN
156: x_cust_account_id := null;

Line 313: FROM hz_cust_accounts

309: THEN
310: BEGIN
311: SELECT party_id
312: INTO p_pb_input_header_rec.customer_attr_value
313: FROM hz_cust_accounts
314: WHERE cust_account_id = p_pb_input_header_rec.cust_account_id;
315: EXCEPTION
316: WHEN OTHERS THEN
317: p_pb_input_header_rec.customer_attr_value := NULL;

Line 889: FROM hz_cust_accounts

885: THEN
886: BEGIN
887: SELECT 1
888: INTO l_count
889: FROM hz_cust_accounts
890: WHERE cust_account_id = p_pb_input_header_rec.cust_account_id
891: AND party_id = p_pb_input_header_rec.customer_attr_value;
892: EXCEPTION
893: WHEN OTHERS THEN

Line 1913: FROM hz_cust_accounts

1909: FROM oe_agreements_vl
1910: WHERE agreement_id = p_pb_input_header_rec.pl_agr_bsa_id
1911: AND (sold_to_org_id = -1 OR
1912: sold_to_org_id IN (SELECT cust_account_id
1913: FROM hz_cust_accounts
1914: WHERE party_id =
1915: p_pb_input_header_rec.customer_attr_value
1916: AND cust_account_id =
1917: nvl(p_pb_input_header_rec.cust_account_id, cust_account_id))

Line 1963: FROM hz_cust_accounts

1959: FROM oe_blanket_headers_all a
1960: WHERE a.header_id = p_pb_input_header_rec.pl_agr_bsa_id
1961: AND (a.sold_to_org_id IS NULL OR
1962: a.sold_to_org_id IN (SELECT cust_account_id
1963: FROM hz_cust_accounts
1964: WHERE party_id =
1965: p_pb_input_header_rec.customer_attr_value
1966: AND cust_account_id =
1967: nvl(p_pb_input_header_rec.cust_account_id, cust_account_id))

Line 2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,

2740: BEGIN
2741: SELECT MCI.CUSTOMER_ITEM_DESC
2742: INTO l_customer_item_desc
2743: FROM MTL_CUSTOMER_ITEMS MCI,
2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,
2745: ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
2746: FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
2748: HZ_PARTY_SITES PARTY_SITE