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

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

Line 9990: FROM okc_k_items cim_model,

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

Line 10995: FROM okc_k_items cim_model,

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

Line 13283: FROM okc_k_items cim_model,

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

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

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