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 903: okc_k_lines_b cle

899: UNION
900: SELECT khr.contract_number contract_number, khr.id khr_id
901: FROM okc_k_headers_b khr,
902: okl_k_control nbd,
903: okc_k_lines_b cle
904: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
905: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))
906: 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 )
907: or (p_inv_cust_acct_id is null and cle.CUST_ACCT_ID = cle.CUST_ACCT_ID))

Line 1319: from okc_k_lines_b chl

1315:
1316: -- Set initial volume
1317: update okl_parallel_processes opp
1318: set volume = (select count(*)
1319: from okc_k_lines_b chl
1320: where chl.dnz_chr_id = opp.khr_id)
1321: WHERE OPP.ASSIGNED_PROCESS = TO_CHAR(l_seq_next); -- bug# 5872306 (ssiruvol)
1322: commit;
1323:

Line 3067: l_chr_id okc_k_lines_b.chr_id%TYPE;

3063: l_update_tbl update_tbl_type;
3064:
3065: l_kle_id NUMBER;
3066: l_top_kle_id NUMBER;
3067: l_chr_id okc_k_lines_b.chr_id%TYPE;
3068: l_asset_name varchar2(2000);
3069: l_prev_khr_id NUMBER;
3070: l_asset_tbl asset_tbl;
3071:

Line 3074: FROM okc_k_lines_b

3070: l_asset_tbl asset_tbl;
3071:
3072: CURSOR check_top_line ( p_cle_id NUMBER ) IS
3073: SELECT chr_id
3074: FROM okc_k_lines_b
3075: WHERE id = p_cle_id;
3076:
3077: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
3078: SELECT name

Line 3085: OKC_K_LINES_B TOP_CLE,

3081:
3082: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
3083: SELECT FA.ID
3084: FROM OKC_K_HEADERS_B CHR,
3085: OKC_K_LINES_B TOP_CLE,
3086: OKC_LINE_STYLES_b TOP_LSE,
3087: OKC_K_LINES_B SUB_CLE,
3088: OKC_LINE_STYLES_b SUB_LSE,
3089: OKC_K_ITEMS CIM,

Line 3087: OKC_K_LINES_B SUB_CLE,

3083: SELECT FA.ID
3084: FROM OKC_K_HEADERS_B CHR,
3085: OKC_K_LINES_B TOP_CLE,
3086: OKC_LINE_STYLES_b TOP_LSE,
3087: OKC_K_LINES_B SUB_CLE,
3088: OKC_LINE_STYLES_b SUB_LSE,
3089: OKC_K_ITEMS CIM,
3090: OKC_K_LINES_V FA,
3091: OKC_LINE_STYLES_B AST_LSE,