DBA Data[Home] [Help]

APPS.BOM_RTG_VAL_TO_ID dependencies on MTL_ITEM_LOCATIONS_KFV

Line 329: /* Bug 4040340. Using mtl_item_locations_kfv to get the locator id.

325: supply_locator_id NUMBER;
326: ret_code NUMBER;
327: l_err_text VARCHAR2(240);
328: BEGIN
329: /* Bug 4040340. Using mtl_item_locations_kfv to get the locator id.
330: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
331: org_id => p_organization_id,
332: flex_code => 'MTLL',
333: flex_name => p_completion_location_name,

Line 346: FROM mtl_item_locations_kfv

342: END IF; */
343:
344: SELECT inventory_location_id
345: INTO supply_locator_id
346: FROM mtl_item_locations_kfv
347: WHERE organization_id = p_organization_id
348: and concatenated_segments = p_completion_location_name;
349:
350: RETURN supply_locator_id;