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 7744: FROM okc_k_lines_b

7740:
7741: -- get the model line id (ITEM) for a financial asset id
7742: CURSOR l_modelline_csr(cp_fin_asset_id IN NUMBER) IS
7743: SELECT id
7744: FROM okc_k_lines_b
7745: WHERE cle_id = cp_fin_asset_id
7746: AND lse_id = 34 ; -- model line LSE ID
7747:
7748: -- Get the vendor for asset/service/fee line

Line 8195: okc_k_lines_b lines,

8191: NULL inventory_item_id
8192: FROM okl_strm_type_b typ,
8193: okl_streams strm,
8194: okl_strm_elements selm,
8195: okc_k_lines_b lines,
8196: okc_line_styles_b lse
8197: WHERE strm.sty_id = typ.id
8198: AND strm.id = selm.stm_id
8199: AND typ.billable_yn = 'Y'

Line 8231: okc_k_lines_b lines,

8227: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8228: FROM okl_strm_type_b typ,
8229: okl_streams strm,
8230: okl_strm_elements selm,
8231: okc_k_lines_b lines,
8232: okc_line_styles_b lse,
8233: okl_bpd_tld_ar_lines_v cnsld
8234: WHERE strm.sty_id = typ.id
8235: AND strm.id = selm.stm_id

Line 8264: okc_k_lines_b lines,

8260: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8261: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8262: FROM okl_strm_type_b typ,
8263: okl_streams strm,
8264: okc_k_lines_b lines,
8265: okc_line_styles_b sty
8266: WHERE strm.sty_id = typ.id
8267: AND typ.billable_yn = 'Y'
8268: AND strm.say_code ='CURR'

Line 8291: okc_k_lines_b lines,

8287: strm.sty_id stream_type_id,
8288: sty.lty_code
8289: FROM okl_strm_type_b typ,
8290: okl_streams strm,
8291: okc_k_lines_b lines,
8292: okc_line_styles_b sty
8293: WHERE strm.sty_id = typ.id
8294: AND typ.billable_yn = 'Y'
8295: AND strm.say_code ='CURR'

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

8302:
8303: -- Get the financial asset associated with a given subline
8304: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS
8305: SELECT cim.object1_id1
8306: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
8307: WHERE cle.lse_id = lse.id
8308: AND lse.lty_code = cp_line_type
8309: AND cim.cle_id = cle.id
8310: AND cle.id = cp_fee_serviced_asset_line_id;

Line 8317: okc_k_lines_b cleb_model,

8313: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
8314: SELECT cim_model.object1_id1,
8315: cim_model.object1_id2
8316: FROM okc_k_items cim_model,
8317: okc_k_lines_b cleb_model,
8318: okc_line_styles_b lseb_model
8319: WHERE cim_model.cle_id = cleb_model.id
8320: AND cleb_model.cle_id = cp_fin_asset_id
8321: AND lseb_model.id = cleb_model.lse_id

Line 9991: okc_k_lines_b cleb_model,

9987: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
9988: SELECT cim_model.object1_id1,
9989: cim_model.object1_id2
9990: FROM okc_k_items cim_model,
9991: okc_k_lines_b cleb_model,
9992: okc_line_styles_b lseb_model
9993: WHERE cim_model.cle_id = cleb_model.id
9994: AND cleb_model.cle_id = cp_fin_asset_id
9995: AND lseb_model.id = cleb_model.lse_id

Line 10996: okc_k_lines_b cleb_model,

10992: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
10993: SELECT cim_model.object1_id1,
10994: cim_model.object1_id2
10995: FROM okc_k_items cim_model,
10996: okc_k_lines_b cleb_model,
10997: okc_line_styles_b lseb_model
10998: WHERE cim_model.cle_id = cleb_model.id
10999: AND cleb_model.cle_id = cp_fin_asset_id
11000: AND lseb_model.id = cleb_model.lse_id

Line 12164: okc_k_lines_b okc

12160: txl.dnz_khr_id,
12161: txl.asset_number,
12162: txl.current_units
12163: FROM okl_txl_assets_b txl,
12164: okc_k_lines_b okc
12165: WHERE txl.tas_id = cp_id
12166: AND txl.kle_id = okc.id
12167: AND txl.dnz_khr_id = okc.dnz_chr_id;
12168:

Line 12173: okc_k_lines_b okc

12169: -- get the trx details information
12170: CURSOR l_txdassets_csr(cp_id IN NUMBER) IS
12171: SELECT txd.id, okc.cle_id target_kle_id, txd.asset_number, txd.split_percent, txd.quantity
12172: FROM okl_txd_assets_b txd,
12173: okc_k_lines_b okc
12174: WHERE tal_id = cp_id
12175: AND txd.target_kle_id = okc.id;
12176:
12177:

Line 13258: FROM okc_k_lines_b cleb,

13254: SELECT rgpb.cle_id line_id,
13255: styb.id stream_type_id,
13256: styb.CODE stream_type_code,
13257: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13258: FROM okc_k_lines_b cleb,
13259: okc_rule_groups_b rgpb,
13260: okc_rules_b rulb,
13261: okc_rules_b rulb2,
13262: okl_strm_type_b styb

Line 13284: okc_k_lines_b cleb_model,

13280: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
13281: SELECT cim_model.object1_id1,
13282: cim_model.object1_id2
13283: FROM okc_k_items cim_model,
13284: okc_k_lines_b cleb_model,
13285: okc_line_styles_b lseb_model
13286: WHERE cim_model.cle_id = cleb_model.id
13287: AND cleb_model.cle_id = cp_fin_asset_id
13288: AND lseb_model.id = cleb_model.lse_id

Line 15048: FROM okc_k_lines_b

15044: AND tax_line_status_code = G_ACTIVE_STATUS;
15045:
15046: CURSOR l_orig_kle_id(cp_kle_id IN NUMBER) IS
15047: SELECT orig_system_id1
15048: FROM okc_k_lines_b
15049: WHERE id = cp_kle_id;
15050:
15051: CURSOR l_new_line_id(cp_orig_system_id IN NUMBER) IS
15052: SELECT id

Line 15053: FROM okc_k_lines_b

15049: WHERE id = cp_kle_id;
15050:
15051: CURSOR l_new_line_id(cp_orig_system_id IN NUMBER) IS
15052: SELECT id
15053: FROM okc_k_lines_b
15054: WHERE orig_system_id1 = cp_orig_system_id;
15055:
15056: TYPE tax_src_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15057: TYPE prev_tx_src_tbl_type IS TABLE OF l_prevtaxsources_csr%ROWTYPE INDEX BY BINARY_INTEGER;

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

15414: IF (l_sync_kle_id IS NOT NULL) THEN
15415: l_txsv_tbl(i).kle_id := l_sync_kle_id;
15416: ELSE
15417: -- This means the asset is newly created during Rebook process, so fetch
15418: -- the id of okc_k_lines_b where the orig_system_id1 is the kle_id of
15419: -- l_rbk_taxablelines_rec
15420: OPEN l_new_line_id(cp_orig_system_id => l_kle_id);
15421: FETCH l_new_line_id INTO l_sync_kle_id;
15422: IF l_new_line_id%NOTFOUND THEN

Line 18958: FROM okc_k_lines_b line, okc_line_styles_b lse

18954:
18955: -- Get the line type
18956: CURSOR l_okclinestyle_csr(cp_kle_id IN NUMBER) IS
18957: SELECT lse.lty_code
18958: FROM okc_k_lines_b line, okc_line_styles_b lse
18959: WHERE line.lse_id = lse.id
18960: AND line.id = cp_kle_id;
18961:
18962: -- Get line name

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

18967:
18968: -- Get the financial asset associated with a given subline
18969: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS
18970: SELECT cim.object1_id1
18971: FROM okc_k_lines_b cle, okc_line_styles_b lse, okc_k_items cim
18972: WHERE cle.lse_id = lse.id
18973: AND lse.lty_code = cp_line_type
18974: AND cim.cle_id = cle.id
18975: AND cle.id = cp_fee_serviced_asset_line_id;

Line 18988: okc_k_lines_b cleb_model,

18984: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
18985: SELECT cim_model.object1_id1,
18986: cim_model.object1_id2
18987: FROM okc_k_items cim_model,
18988: okc_k_lines_b cleb_model,
18989: okc_line_styles_b lseb_model
18990: WHERE cim_model.cle_id = cleb_model.id
18991: AND cleb_model.cle_id = cp_fin_asset_id
18992: AND lseb_model.id = cleb_model.lse_id