eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_K_LINES_B

Line 60: okc_k_lines_b inst,

56: -- csi.location_id
57: csi.install_location_type_code
58: FROM csi_item_instances csi,
59: okc_k_items cim,
60: okc_k_lines_b inst,
61: okc_k_lines_b ib,
62: okc_line_styles_b lse
63: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
64: AND cim.cle_id = ib.id

Line 61: okc_k_lines_b ib,

57: csi.install_location_type_code
58: FROM csi_item_instances csi,
59: okc_k_items cim,
60: okc_k_lines_b inst,
61: okc_k_lines_b ib,
62: okc_line_styles_b lse
63: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
64: AND cim.cle_id = ib.id
65: AND ib.cle_id = inst.id

Line 73: FROM okc_k_lines_b inst,

69:
70: -- get the Install Base Line ID (INST_ITEM) for the financial asset
71: CURSOR l_institem_csr(cp_fin_asset_id IN NUMBER) IS
72: SELECT ib.id inst_item_id
73: FROM okc_k_lines_b inst,
74: okc_k_lines_b ib
75: WHERE ib.cle_id = inst.id
76: AND inst.lse_id = 43
77: AND inst.cle_id = cp_fin_asset_id;

Line 74: okc_k_lines_b ib

70: -- get the Install Base Line ID (INST_ITEM) for the financial asset
71: CURSOR l_institem_csr(cp_fin_asset_id IN NUMBER) IS
72: SELECT ib.id inst_item_id
73: FROM okc_k_lines_b inst,
74: okc_k_lines_b ib
75: WHERE ib.cle_id = inst.id
76: AND inst.lse_id = 43
77: AND inst.cle_id = cp_fin_asset_id;
78:

Line 7775: FROM okc_k_lines_b

7771:
7772: -- get the model line id (ITEM) for a financial asset id
7773: CURSOR l_modelline_csr(cp_fin_asset_id IN NUMBER) IS
7774: SELECT id
7775: FROM okc_k_lines_b
7776: WHERE cle_id = cp_fin_asset_id
7777: AND lse_id = 34 ; -- model line LSE ID
7778:
7779: -- Get the vendor for asset/service/fee line

Line 8226: okc_k_lines_b lines,

8222: NULL inventory_item_id
8223: FROM okl_strm_type_b typ,
8224: okl_streams strm,
8225: okl_strm_elements selm,
8226: okc_k_lines_b lines,
8227: okc_line_styles_b lse
8228: WHERE strm.sty_id = typ.id
8229: AND strm.id = selm.stm_id
8230: AND typ.billable_yn = 'Y'

Line 8262: okc_k_lines_b lines,

8258: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8259: FROM okl_strm_type_b typ,
8260: okl_streams strm,
8261: okl_strm_elements selm,
8262: okc_k_lines_b lines,
8263: okc_line_styles_b lse,
8264: okl_bpd_tld_ar_lines_v cnsld
8265: WHERE strm.sty_id = typ.id
8266: AND strm.id = selm.stm_id

Line 8295: okc_k_lines_b lines,

8291: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8292: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8293: FROM okl_strm_type_b typ,
8294: okl_streams strm,
8295: okc_k_lines_b lines,
8296: okc_line_styles_b sty
8297: WHERE strm.sty_id = typ.id
8298: AND typ.billable_yn = 'Y'
8299: AND strm.say_code ='CURR'

Line 8322: okc_k_lines_b lines,

8318: strm.sty_id stream_type_id,
8319: sty.lty_code
8320: FROM okl_strm_type_b typ,
8321: okl_streams strm,
8322: okc_k_lines_b lines,
8323: okc_line_styles_b sty
8324: WHERE strm.sty_id = typ.id
8325: AND typ.billable_yn = 'Y'
8326: AND strm.say_code ='CURR'

Line 8337: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim

8333:
8334: -- Get the financial asset associated with a given subline
8335: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS
8336: SELECT cim.object1_id1
8337: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
8338: WHERE cle.lse_id = lse.id
8339: AND lse.lty_code = cp_line_type
8340: AND cim.cle_id = cle.id
8341: AND cle.id = cp_fee_serviced_asset_line_id;

Line 8348: okc_k_lines_b cleb_model,

8344: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
8345: SELECT cim_model.object1_id1,
8346: cim_model.object1_id2
8347: FROM okc_k_items cim_model,
8348: okc_k_lines_b cleb_model,
8349: okc_line_styles_b lseb_model
8350: WHERE cim_model.cle_id = cleb_model.id
8351: AND cleb_model.cle_id = cp_fin_asset_id
8352: AND lseb_model.id = cleb_model.lse_id

Line 10024: okc_k_lines_b cleb_model,

10020: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
10021: SELECT cim_model.object1_id1,
10022: cim_model.object1_id2
10023: FROM okc_k_items cim_model,
10024: okc_k_lines_b cleb_model,
10025: okc_line_styles_b lseb_model
10026: WHERE cim_model.cle_id = cleb_model.id
10027: AND cleb_model.cle_id = cp_fin_asset_id
10028: AND lseb_model.id = cleb_model.lse_id

Line 11031: okc_k_lines_b cleb_model,

11027: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
11028: SELECT cim_model.object1_id1,
11029: cim_model.object1_id2
11030: FROM okc_k_items cim_model,
11031: okc_k_lines_b cleb_model,
11032: okc_line_styles_b lseb_model
11033: WHERE cim_model.cle_id = cleb_model.id
11034: AND cleb_model.cle_id = cp_fin_asset_id
11035: AND lseb_model.id = cleb_model.lse_id

Line 12199: okc_k_lines_b okc

12195: txl.dnz_khr_id,
12196: txl.asset_number,
12197: txl.current_units
12198: FROM okl_txl_assets_b txl,
12199: okc_k_lines_b okc
12200: WHERE txl.tas_id = cp_id
12201: AND txl.kle_id = okc.id
12202: AND txl.dnz_khr_id = okc.dnz_chr_id;
12203:

Line 12208: okc_k_lines_b okc

12204: -- get the trx details information
12205: CURSOR l_txdassets_csr(cp_id IN NUMBER) IS
12206: SELECT txd.id, okc.cle_id target_kle_id, txd.asset_number, txd.split_percent, txd.quantity
12207: FROM okl_txd_assets_b txd,
12208: okc_k_lines_b okc
12209: WHERE tal_id = cp_id
12210: AND txd.target_kle_id = okc.id;
12211:
12212:

Line 13318: FROM okc_k_lines_b cleb,

13314: SELECT rgpb.cle_id line_id,
13315: styb.id stream_type_id,
13316: styb.CODE stream_type_code,
13317: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13318: FROM okc_k_lines_b cleb,
13319: okc_rule_groups_b rgpb,
13320: okc_rules_b rulb,
13321: okc_rules_b rulb2,
13322: okl_strm_type_b styb

Line 13353: okc_k_lines_b cleb_model,

13349: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
13350: SELECT cim_model.object1_id1,
13351: cim_model.object1_id2
13352: FROM okc_k_items cim_model,
13353: okc_k_lines_b cleb_model,
13354: okc_line_styles_b lseb_model
13355: WHERE cim_model.cle_id = cleb_model.id
13356: AND cleb_model.cle_id = cp_fin_asset_id
13357: AND lseb_model.id = cleb_model.lse_id

Line 15119: FROM okc_k_lines_b

15115: AND tax_line_status_code = G_ACTIVE_STATUS;
15116:
15117: CURSOR l_orig_kle_id(cp_kle_id IN NUMBER) IS
15118: SELECT orig_system_id1
15119: FROM okc_k_lines_b
15120: WHERE id = cp_kle_id;
15121:
15122: CURSOR l_new_line_id(cp_orig_system_id IN NUMBER) IS
15123: SELECT id

Line 15124: FROM okc_k_lines_b

15120: WHERE id = cp_kle_id;
15121:
15122: CURSOR l_new_line_id(cp_orig_system_id IN NUMBER) IS
15123: SELECT id
15124: FROM okc_k_lines_b
15125: WHERE orig_system_id1 = cp_orig_system_id;
15126:
15127: TYPE tax_src_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15128: TYPE prev_tx_src_tbl_type IS TABLE OF l_prevtaxsources_csr%ROWTYPE INDEX BY BINARY_INTEGER;

Line 15490: -- the id of okc_k_lines_b where the orig_system_id1 is the kle_id of

15486: IF (l_sync_kle_id IS NOT NULL) THEN
15487: l_txsv_tbl(i).kle_id := l_sync_kle_id;
15488: ELSE
15489: -- This means the asset is newly created during Rebook process, so fetch
15490: -- the id of okc_k_lines_b where the orig_system_id1 is the kle_id of
15491: -- l_rbk_taxablelines_rec
15492: OPEN l_new_line_id(cp_orig_system_id => l_kle_id);
15493: FETCH l_new_line_id INTO l_sync_kle_id;
15494: IF l_new_line_id%NOTFOUND THEN

Line 17584: okc_k_lines_b cle

17580: CURSOR get_ast_reloc_khr(p_trx_id okl_trx_assets.ID%TYPE) IS
17581: SELECT cle.dnz_chr_id
17582: FROM okl_trx_assets trx,
17583: okl_txl_itm_insts inst,
17584: okc_k_lines_b cle
17585: WHERE trx.tas_type = 'ALG'
17586: AND inst.tas_id = trx.ID
17587: AND cle.ID = inst.kle_id
17588: AND trx.id = p_trx_id;

Line 19125: FROM okc_k_lines_b line, okc_line_styles_b lse

19121:
19122: -- Get the line type
19123: CURSOR l_okclinestyle_csr(cp_kle_id IN NUMBER) IS
19124: SELECT lse.lty_code
19125: FROM okc_k_lines_b line, okc_line_styles_b lse
19126: WHERE line.lse_id = lse.id
19127: AND line.id = cp_kle_id;
19128:
19129: -- Get line name

Line 19138: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim

19134:
19135: -- Get the financial asset associated with a given subline
19136: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS
19137: SELECT cim.object1_id1
19138: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
19139: WHERE cle.lse_id = lse.id
19140: AND lse.lty_code = cp_line_type
19141: AND cim.cle_id = cle.id
19142: AND cle.id = cp_fee_serviced_asset_line_id;

Line 19155: okc_k_lines_b cleb_model,

19151: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
19152: SELECT cim_model.object1_id1,
19153: cim_model.object1_id2
19154: FROM okc_k_items cim_model,
19155: okc_k_lines_b cleb_model,
19156: okc_line_styles_b lseb_model
19157: WHERE cim_model.cle_id = cleb_model.id
19158: AND cleb_model.cle_id = cp_fin_asset_id
19159: AND lseb_model.id = cleb_model.lse_id