APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_K_LINES_V

Line 670: l_asset_name okc_k_lines_v.name%TYPE;

666: l_ship_to NUMBER;
667: l_kle_id NUMBER;
668: l_top_kle_id NUMBER;
669: l_chr_id okc_k_lines_b.chr_id%TYPE;
670: l_asset_name okc_k_lines_v.name%TYPE;
671: l_install_location_id NUMBER;
672: l_location_id NUMBER;
673: --start: 02-APR-07 cklee R12 Billing enhancement project |
674: -- l_exempt_flg okl_ext_sell_invs_v.tax_exempt_flag%TYPE;

Line 698: OKC_K_LINES_V FA,

694: OKC_LINE_STYLES_b TOP_LSE,
695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
697: OKC_K_ITEMS CIM,
698: OKC_K_LINES_V FA,
699: OKC_LINE_STYLES_B AST_LSE,
700: OKL_CNSLD_AR_STRMS_B LSM
701: WHERE
702: CHR.ID = TOP_CLE.DNZ_CHR_ID AND

Line 720: FROM okc_k_lines_v

716: --end: 02-APR-07 cklee R12 Billing enhancement project |
717:
718: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
719: SELECT name
720: FROM okc_k_lines_v
721: WHERE id = p_cle_id;
722:
723:
724: CURSOR Ship_to_csr( p_kle_top_line IN NUMBER ) IS

Line 797: from OKC_K_LINES_V cle

793: connect by cle.id = prior cle.cle_id;
794:
795: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
796: select cle.name
797: from OKC_K_LINES_V cle
798: where cle.id = p_cle_id;
799:
800: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
801:

Line 1129: l_asset_name okc_k_lines_v.name%TYPE;

1125: l_ship_to NUMBER;
1126: l_kle_id NUMBER;
1127: l_top_kle_id NUMBER;
1128: l_chr_id okc_k_lines_b.chr_id%TYPE;
1129: l_asset_name okc_k_lines_v.name%TYPE;
1130: l_install_location_id NUMBER;
1131: l_location_id NUMBER;
1132: --start: 02-APR-07 cklee R12 Billing enhancement project |
1133: -- l_exempt_flg okl_ext_sell_invs_v.tax_exempt_flag%TYPE;

Line 1154: OKC_K_LINES_V FA,

1150: OKC_LINE_STYLES_b TOP_LSE,
1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1153: OKC_K_ITEMS CIM,
1154: OKC_K_LINES_V FA,
1155: OKC_LINE_STYLES_B AST_LSE,
1156: OKL_CNSLD_AR_STRMS_B LSM
1157: WHERE
1158: CHR.ID = TOP_CLE.DNZ_CHR_ID AND

Line 1176: FROM okc_k_lines_v

1172: --end: 02-APR-07 cklee R12 Billing enhancement project |
1173:
1174: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
1175: SELECT name
1176: FROM okc_k_lines_v
1177: WHERE id = p_cle_id;
1178:
1179:
1180: CURSOR Ship_to_csr( p_kle_top_line IN NUMBER ) IS

Line 1217: FROM okc_k_lines_v a,

1213: lx_customer_id NUMBER;
1214: l_temp_sold_fee VARCHAR2(1);
1215: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1216: SELECT '1'
1217: FROM okc_k_lines_v a,
1218: okc_line_styles_v b
1219: WHERE a.lse_id = b.id
1220: AND b.lty_code = 'SOLD_SERVICE'
1221: AND a.id = p_cle_id;

Line 1225: FROM okc_k_lines_v a,

1221: AND a.id = p_cle_id;
1222:
1223: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1224: SELECT c.object1_id1
1225: FROM okc_k_lines_v a,
1226: okc_line_styles_v b,
1227: okc_k_items c
1228: WHERE a.lse_id = b.id
1229: AND b.lty_code = 'SOLD_SERVICE'

Line 1293: from OKC_K_LINES_V cle

1289: connect by cle.id = prior cle.cle_id;
1290:
1291: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
1292: select cle.name
1293: from OKC_K_LINES_V cle
1294: where cle.id = p_cle_id;
1295:
1296: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1297: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 2087: -- OKC_K_LINES_V KLE,

2083: OKL_TXL_AR_INV_LNS_V TIL,
2084: OKL_TRX_AR_INVOICES_V TAI,
2085: OKC_K_HEADERS_ALL_B KHR,
2086: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2087: -- OKC_K_LINES_V KLE,
2088: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2089: OKL_STRM_TYPE_V STY,
2090: OKL_TRX_TYPES_TL TRYT--,
2091: -- OKL_PARALLEL_PROCESSES OPP