APPS.OKS_MISC_UTIL_WEB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 926: FROM mtl_system_items_kfv mtl

922:
923: CURSOR get_prod_name_csr IS
924: SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC'
925: , mtl.description,mtl.concatenated_segments)
926: FROM mtl_system_items_kfv mtl
927: ,okc_k_items itm
928: ,csi_item_instances csi
929: WHERE itm.object1_id1 = p_object1_id1
930: AND itm.jtot_object1_code = p_jtot_object1_code

Line 939: FROM mtl_system_items_kfv mtl

935:
936: CURSOR get_item_name_csr IS
937: SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC'
938: , mtl.description,mtl.concatenated_segments)
939: FROM mtl_system_items_kfv mtl
940: WHERE mtl.inventory_item_id = to_number(p_object1_id1)
941: AND mtl.organization_id = p_object1_id2;
942:
943: CURSOR get_party_name_csr IS