DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_K_HEADERS_B

Line 35: okc_k_headers_b okch,

31: SELECT oklh.id khr_id,
32: okch.contract_number,
33: nvl(stm.kle_id, -99) kle_id
34: FROM okl_k_headers oklh,
35: okc_k_headers_b okch,
36: okc_statuses_b khs,
37: okl_streams stm
38: WHERE oklh.id = okch.id
39: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)

Line 67: okc_k_headers_b okch,

63: SELECT distinct oklh.id khr_id,
64: okch.contract_number,
65: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bkrpcy_sts
66: FROM okl_k_headers oklh,
67: okc_k_headers_b okch,
68: okc_statuses_b khs,
69: okl_streams stm,
70: hz_cust_accounts hca
71: WHERE oklh.id = okch.id