DBA Data[Home] [Help]

APPS.OKC_CREATE_PO_FROM_K_PUB dependencies on OKC_K_REL_OBJS

Line 428: FROM okc_k_rel_objs rel

424: INTO l_po_number
425: FROM po_headers_all po
426: WHERE po.po_header_id =
427: ( SELECT object1_id1
428: FROM okc_k_rel_objs rel
429: WHERE rel.chr_id = p_contract_id -- for the current contract
430: AND rel.cle_id IS NULL -- related obj pertains to header
431: AND rel.rty_code = g_crj_rty_code -- for PO creation
432: AND rel.jtot_object1_code = g_crj_chr_jtot_object_code -- correct jtot object