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 OE_BLANKET_HEADERS_ALL

Line 135: FROM oe_blanket_headers_all

131: x_return NUMBER;
132: BEGIN
133: SELECT header_id
134: INTO x_return
135: FROM oe_blanket_headers_all
136: WHERE order_number = p_bsa_name;
137: RETURN x_return;
138: EXCEPTION
139: WHEN OTHERS THEN

Line 1959: FROM oe_blanket_headers_all a

1955: ELSIF p_pb_input_header_rec.price_based_on = 'BSA' THEN
1956: BEGIN
1957: SELECT 1
1958: INTO l_count
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