APPS.OKL_CONS_BILL dependencies on OKC_K_LINES_V

Line 1004: l_asset_name okc_k_lines_v.name%TYPE;

1000:
1001: l_kle_id NUMBER;
1002: l_top_kle_id NUMBER;
1003: l_chr_id okc_k_lines_b.chr_id%TYPE;
1004: l_asset_name okc_k_lines_v.name%TYPE;
1005:
1006: CURSOR check_top_line ( p_cle_id NUMBER ) IS
1007: SELECT chr_id
1008: FROM okc_k_lines_b

Line 1013: FROM okc_k_lines_v

1009: WHERE id = p_cle_id;
1010:
1011: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
1012: SELECT name
1013: FROM okc_k_lines_v
1014: WHERE id = p_cle_id;
1015:
1016: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1017: SELECT FA.ID

Line 1024: OKC_K_LINES_V FA,

1020: OKC_LINE_STYLES_b TOP_LSE,
1021: OKC_K_LINES_B SUB_CLE,
1022: OKC_LINE_STYLES_b SUB_LSE,
1023: OKC_K_ITEMS CIM,
1024: OKC_K_LINES_V FA,
1025: OKC_LINE_STYLES_B AST_LSE,
1026: OKL_CNSLD_AR_STRMS_B LSM
1027: WHERE
1028: CHR.ID = TOP_CLE.DNZ_CHR_ID AND

Line 1928: OKC_K_LINES_V FA,

1924: OKC_LINE_STYLES_b TOP_LSE,
1925: OKC_K_LINES_B SUB_CLE,
1926: OKC_LINE_STYLES_b SUB_LSE,
1927: OKC_K_ITEMS CIM,
1928: OKC_K_LINES_V FA,
1929: OKC_LINE_STYLES_B AST_LSE,
1930: OKL_CNSLD_AR_STRMS_B LSM
1931: WHERE
1932: CHR.ID = TOP_CLE.DNZ_CHR_ID AND