DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_K_HEADERS_B

Line 26: okc_k_headers_b okch,

22: SELECT oklh.id khr_id,
23: okch.contract_number,
24: nvl(stm.kle_id, -99) kle_id
25: FROM okl_k_headers oklh,
26: okc_k_headers_b okch,
27: okc_statuses_b khs,
28: okl_streams stm
29: WHERE oklh.id = okch.id
30: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)