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 OKC_K_HEADERS_B

Line 297: SELECT chr.id FROM okc_k_headers_b chr, okc_statuses_b sts

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
298: WHERE chr.contract_number = p_contract_number
299: AND chr.sts_code = sts.code AND sts.ste_code in ('ACTIVE', 'SIGNED');
300: l_contract_id NUMBER;
301: CURSOR osp_order_on_csr(p_osp_order_number IN NUMBER) IS

Line 736: SELECT 'x' FROM okc_k_headers_b chr, okc_k_party_roles_b cpl, okc_statuses_b sts

732: p_authoring_org_id IN VARCHAR2
733: )IS
734: CURSOR val_contract_id_csr(p_contract_id IN NUMBER,p_party_vendor_id in NUMBER,
735: p_buy_or_sell IN VARCHAR2, p_authoring_org_id IN NUMBER, p_object_code IN VARCHAR2) IS
736: SELECT 'x' FROM okc_k_headers_b chr, okc_k_party_roles_b cpl, okc_statuses_b sts
737: WHERE chr.id = p_contract_id
738: AND cpl.object1_id1 = p_party_vendor_id
739: AND chr.authoring_org_id = p_authoring_org_id
740: AND chr.id = cpl.chr_id AND chr.buy_or_sell = p_buy_or_sell AND chr.sts_code = sts.code AND sts.ste_code in ('ACTIVE', 'SIGNED')