APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_K_LINES_V

Line 428: l_asset_name okc_k_lines_v.name%TYPE;

424: l_ship_to NUMBER;
425: l_kle_id NUMBER;
426: l_top_kle_id NUMBER;
427: l_chr_id okc_k_lines_b.chr_id%TYPE;
428: l_asset_name okc_k_lines_v.name%TYPE;
429: l_install_location_id NUMBER;
430: l_location_id NUMBER;
431: --start: 02-APR-07 cklee R12 Billing enhancement project |
432: -- l_exempt_flg okl_ext_sell_invs_v.tax_exempt_flag%TYPE;

Line 456: OKC_K_LINES_V FA,

452: OKC_LINE_STYLES_b TOP_LSE,
453: OKC_K_LINES_B SUB_CLE,
454: OKC_LINE_STYLES_b SUB_LSE,
455: OKC_K_ITEMS CIM,
456: OKC_K_LINES_V FA,
457: OKC_LINE_STYLES_B AST_LSE,
458: OKL_CNSLD_AR_STRMS_B LSM
459: WHERE
460: CHR.ID = TOP_CLE.DNZ_CHR_ID AND

Line 478: FROM okc_k_lines_v

474: --end: 02-APR-07 cklee R12 Billing enhancement project |
475:
476: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
477: SELECT name
478: FROM okc_k_lines_v
479: WHERE id = p_cle_id;
480:
481:
482: CURSOR Ship_to_csr( p_kle_top_line IN NUMBER ) IS

Line 555: from OKC_K_LINES_V cle

551: connect by cle.id = prior cle.cle_id;
552:
553: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
554: select cle.name
555: from OKC_K_LINES_V cle
556: where cle.id = p_cle_id;
557:
558: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
559:

Line 921: l_asset_name okc_k_lines_v.name%TYPE;

917: l_ship_to NUMBER;
918: l_kle_id NUMBER;
919: l_top_kle_id NUMBER;
920: l_chr_id okc_k_lines_b.chr_id%TYPE;
921: l_asset_name okc_k_lines_v.name%TYPE;
922: l_install_location_id NUMBER;
923: l_location_id NUMBER;
924: --start: 02-APR-07 cklee R12 Billing enhancement project |
925: -- l_exempt_flg okl_ext_sell_invs_v.tax_exempt_flag%TYPE;

Line 946: OKC_K_LINES_V FA,

942: OKC_LINE_STYLES_b TOP_LSE,
943: OKC_K_LINES_B SUB_CLE,
944: OKC_LINE_STYLES_b SUB_LSE,
945: OKC_K_ITEMS CIM,
946: OKC_K_LINES_V FA,
947: OKC_LINE_STYLES_B AST_LSE,
948: OKL_CNSLD_AR_STRMS_B LSM
949: WHERE
950: CHR.ID = TOP_CLE.DNZ_CHR_ID AND

Line 968: FROM okc_k_lines_v

964: --end: 02-APR-07 cklee R12 Billing enhancement project |
965:
966: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
967: SELECT name
968: FROM okc_k_lines_v
969: WHERE id = p_cle_id;
970:
971:
972: CURSOR Ship_to_csr( p_kle_top_line IN NUMBER ) IS

Line 1009: FROM okc_k_lines_v a,

1005: lx_customer_id NUMBER;
1006: l_temp_sold_fee VARCHAR2(1);
1007: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1008: SELECT '1'
1009: FROM okc_k_lines_v a,
1010: okc_line_styles_v b
1011: WHERE a.lse_id = b.id
1012: AND b.lty_code = 'SOLD_SERVICE'
1013: AND a.id = p_cle_id;

Line 1017: FROM okc_k_lines_v a,

1013: AND a.id = p_cle_id;
1014:
1015: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1016: SELECT c.object1_id1
1017: FROM okc_k_lines_v a,
1018: okc_line_styles_v b,
1019: okc_k_items c
1020: WHERE a.lse_id = b.id
1021: AND b.lty_code = 'SOLD_SERVICE'

Line 1085: from OKC_K_LINES_V cle

1081: connect by cle.id = prior cle.cle_id;
1082:
1083: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
1084: select cle.name
1085: from OKC_K_LINES_V cle
1086: where cle.id = p_cle_id;
1087:
1088: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1089: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 1879: -- OKC_K_LINES_V KLE,

1875: OKL_TXL_AR_INV_LNS_V TIL,
1876: OKL_TRX_AR_INVOICES_V TAI,
1877: OKC_K_HEADERS_ALL_B KHR,
1878: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1879: -- OKC_K_LINES_V KLE,
1880: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1881: OKL_STRM_TYPE_V STY,
1882: OKL_TRX_TYPES_TL TRYT--,
1883: -- OKL_PARALLEL_PROCESSES OPP