APPS.BOMPCMBM dependencies on MTL_SYSTEM_ITEMS_VL

Line 312: FROM MTL_SYSTEM_ITEMS_VL

308:
309: /* Get the "common item from" item name */
310: SELECT concatenated_segments
311: INTO common_item_from_name
312: FROM MTL_SYSTEM_ITEMS_VL
313: WHERE inventory_item_id = common_item_from
314: AND organization_id = current_org_id;
315:
316: /* Get the "common org to" Organization code */

Line 328: FROM MTL_SYSTEM_ITEMS_VL

324: /* Get the "common Item to" item id */
325: IF (scope = 1) AND (common_item_to is not null) then
326: SELECT concatenated_segments, description
327: INTO common_item_to_name,l_item_desc
328: FROM MTL_SYSTEM_ITEMS_VL
329: WHERE inventory_item_id = common_item_to
330: AND organization_id = common_org_to ;
331: END IF ;
332:

Line 410: FROM MTL_SYSTEM_ITEMS_VL

406: IF (scope = 2 OR scope = 3) THEN
407: BEGIN
408: SELECT concatenated_segments, DESCRIPTION
409: INTO l_assy_item_name, l_item_desc
410: FROM MTL_SYSTEM_ITEMS_VL
411: WHERE organization_id = t_org_code_list(I)
412: AND inventory_item_id = common_item_from ;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN