APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_PROFILE

Line 123: FROM fnd_profile_options a, fnd_profile_option_values b

119: item_code = p_item_code;
120:
121: CURSOR c_get_um_type IS
122: SELECT profile_option_value
123: FROM fnd_profile_options a, fnd_profile_option_values b
124: WHERE b.level_id = 10001 and
125: a.profile_option_id = b.profile_option_id and
126: a.profile_option_name = 'FM_YIELD_TYPE';
127:

Line 489: fnd_profile.value ('INV_STATUS_DEFAULT');

485: END IF;
486:
487: IF (g_inv_item_status_code is NULL) THEN
488: g_inv_item_status_code :=
489: fnd_profile.value ('INV_STATUS_DEFAULT');
490: END IF;
491:
492: l_inventory_item_flag := 'Y';
493: l_inventory_asset_flag := 'Y';