APPS.OKS_MISC_UTIL_WEB dependencies on FND_PROFILE

Line 924: SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC'

920: l_chr_id NUMBER;
921: l_api_name CONSTANT VARCHAR2(30) := 'get_covlvl_name';
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

Line 937: SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC'

933: AND mtl.organization_id = csi.inv_master_organization_id
934: AND rownum < 2;
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;