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_LINE_STYLES_B

Line 62: okc_line_styles_b lse

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
66: AND inst.lse_id = lse.id

Line 8227: okc_line_styles_b lse

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'
8231: AND strm.say_code ='CURR'

Line 8263: okc_line_styles_b lse,

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
8267: AND typ.billable_yn = 'Y'

Line 8296: okc_line_styles_b sty

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'
8300: AND strm.active_yn = 'Y'

Line 8323: okc_line_styles_b sty

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'
8327: AND strm.active_yn = 'Y'

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 8349: okc_line_styles_b lseb_model

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
8353: AND lseb_model.lty_code = 'ITEM';

Line 10025: okc_line_styles_b lseb_model

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
10029: AND lseb_model.lty_code = 'ITEM';

Line 11032: okc_line_styles_b lseb_model

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
11036: AND lseb_model.lty_code = 'ITEM';

Line 13354: okc_line_styles_b lseb_model

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
13358: AND lseb_model.lty_code = 'ITEM';

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 19156: okc_line_styles_b lseb_model

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
19160: AND lseb_model.lty_code = 'ITEM';