APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_K_ITEMS

Line 59: okc_k_items cim,

55: SELECT csi.install_location_id,
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)

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 8347: FROM okc_k_items cim_model,

8343: -- get the inventory item id and inventory item org for a financial asset
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

Line 10023: FROM okc_k_items cim_model,

10019: -- get the inventory item id and inventory item org for a financial asset
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

Line 11030: FROM okc_k_items cim_model,

11026: -- get the inventory item id and inventory item org for a financial asset
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

Line 13352: FROM okc_k_items cim_model,

13348: -- get the inventory item id and inventory item org for a financial asset
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

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 19154: FROM okc_k_items cim_model,

19150: -- get the inventory item id and inventory item org for a financial asset
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