DBA Data[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OKC_K_REL_OBJS_V

Line 694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line

690:
691: CURSOR l_contract_csr (p_ordlineid NUMBER)
692: IS
693: SELECT rel.cle_id, rel.chr_id
694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line
695: WHERE rel.object1_id1 = TO_CHAR (p_ordlineid)
696: AND rel.jtot_object1_code = 'OKX_ORDERLINE'
697: AND line.ID = rel.cle_id
698: AND line.lse_id IN (9, 25);