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 8196: okc_line_styles_b lse

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

Line 8232: okc_line_styles_b lse,

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

Line 8265: okc_line_styles_b sty

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

Line 8292: okc_line_styles_b sty

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

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

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

Line 9992: okc_line_styles_b lseb_model

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

Line 10997: okc_line_styles_b lseb_model

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

Line 13285: okc_line_styles_b lseb_model

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

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

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