APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKC_K_LINES_B

Line 35: okc_k_lines_b kle,

31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,
35: okc_k_lines_b kle,
36: okc_statuses_b khs,
37: okc_statuses_b kls
38: WHERE ste.amount <> 0
39: AND stm.id = ste.stm_id

Line 915: okc_k_lines_b cle

911: UNION
912: SELECT khr.contract_number contract_number, khr.id khr_id
913: FROM okc_k_headers_b khr,
914: okl_k_control nbd,
915: okc_k_lines_b cle
916: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
917: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))
918: AND ((p_inv_cust_acct_id is not null and cle.CUST_ACCT_ID IS NOT NULL AND cle.CUST_ACCT_ID = p_inv_cust_acct_id )
919: or (p_inv_cust_acct_id is null and cle.CUST_ACCT_ID = cle.CUST_ACCT_ID))

Line 1356: from okc_k_lines_b chl

1352:
1353: -- Set initial volume
1354: update okl_parallel_processes opp
1355: set volume = (select count(*)
1356: from okc_k_lines_b chl
1357: where chl.dnz_chr_id = opp.khr_id)
1358: WHERE OPP.ASSIGNED_PROCESS = TO_CHAR(l_seq_next); -- bug# 5872306 (ssiruvol)
1359: commit;
1360:

Line 3131: l_chr_id okc_k_lines_b.chr_id%TYPE;

3127: l_update_tbl update_tbl_type;
3128:
3129: l_kle_id NUMBER;
3130: l_top_kle_id NUMBER;
3131: l_chr_id okc_k_lines_b.chr_id%TYPE;
3132: l_asset_name varchar2(2000);
3133: l_prev_khr_id NUMBER;
3134: l_asset_tbl asset_tbl;
3135:

Line 3138: FROM okc_k_lines_b

3134: l_asset_tbl asset_tbl;
3135:
3136: CURSOR check_top_line ( p_cle_id NUMBER ) IS
3137: SELECT chr_id
3138: FROM okc_k_lines_b
3139: WHERE id = p_cle_id;
3140:
3141: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
3142: SELECT name

Line 3149: OKC_K_LINES_B TOP_CLE,

3145:
3146: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
3147: SELECT FA.ID
3148: FROM OKC_K_HEADERS_B CHR,
3149: OKC_K_LINES_B TOP_CLE,
3150: OKC_LINE_STYLES_b TOP_LSE,
3151: OKC_K_LINES_B SUB_CLE,
3152: OKC_LINE_STYLES_b SUB_LSE,
3153: OKC_K_ITEMS CIM,

Line 3151: OKC_K_LINES_B SUB_CLE,

3147: SELECT FA.ID
3148: FROM OKC_K_HEADERS_B CHR,
3149: OKC_K_LINES_B TOP_CLE,
3150: OKC_LINE_STYLES_b TOP_LSE,
3151: OKC_K_LINES_B SUB_CLE,
3152: OKC_LINE_STYLES_b SUB_LSE,
3153: OKC_K_ITEMS CIM,
3154: OKC_K_LINES_V FA,
3155: OKC_LINE_STYLES_B AST_LSE,