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

Line 293: SELECT party_id from hz_parties

289: SELECT buyer_id FROM po_agents_name_v
290: WHERE full_name = p_buyer_name;
291: l_po_agent_id NUMBER;
292: CURSOR customer_id_csr(p_customer_name IN VARCHAR2) IS
293: SELECT party_id from hz_parties
294: where party_name = p_customer_name and party_type = 'ORGANIZATION';
295: l_customer_id NUMBER;
296: CURSOR contract_id_csr(p_contract_number IN VARCHAR2) IS
297: SELECT chr.id FROM okc_k_headers_b chr, okc_statuses_b sts

Line 676: SELECT 'x' from hz_parties

672: PROCEDURE validate_customer(
673: p_customer_id IN NUMBER
674: )IS
675: CURSOR val_customer_id_csr(p_customer_id IN NUMBER) IS
676: SELECT 'x' from hz_parties
677: where party_id = p_customer_id and party_type = 'ORGANIZATION';
678: l_exist VARCHAR2(1);
679: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_customer';
680: BEGIN