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 314: SELECT party_id from hz_parties

310: SELECT buyer_id FROM po_agents_name_v
311: WHERE full_name = p_buyer_name;
312: l_po_agent_id NUMBER;
313: CURSOR customer_id_csr(p_customer_name IN VARCHAR2) IS
314: SELECT party_id from hz_parties
315: where party_name = p_customer_name and party_type = 'ORGANIZATION';
316: l_customer_id NUMBER;
317: CURSOR contract_id_csr(p_contract_number IN VARCHAR2) IS
318: SELECT chr.id FROM okc_k_headers_b chr, okc_statuses_b sts

Line 697: SELECT 'x' from hz_parties

693: PROCEDURE validate_customer(
694: p_customer_id IN NUMBER
695: )IS
696: CURSOR val_customer_id_csr(p_customer_id IN NUMBER) IS
697: SELECT 'x' from hz_parties
698: where party_id = p_customer_id and party_type = 'ORGANIZATION';
699: l_exist VARCHAR2(1);
700: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_customer';
701: BEGIN