APPS.BOMPCMBM dependencies on MTL_SYSTEM_ITEMS_VL

Line 214: FROM MTL_SYSTEM_ITEMS_VL

210:
211: /* Get the "common item from" item name */
212: SELECT concatenated_segments
213: INTO common_item_from_name
214: FROM MTL_SYSTEM_ITEMS_VL
215: WHERE inventory_item_id = common_item_from
216: AND organization_id = current_org_id;
217:
218: /* Get the "common org to" Organization code */

Line 230: FROM MTL_SYSTEM_ITEMS_VL

226: /* Get the "common Item to" item id */
227: IF (scope = 1) AND (common_item_to is not null) then
228: SELECT concatenated_segments, description
229: INTO common_item_to_name,l_item_desc
230: FROM MTL_SYSTEM_ITEMS_VL
231: WHERE inventory_item_id = common_item_to
232: AND organization_id = common_org_to ;
233: END IF ;
234:

Line 312: FROM MTL_SYSTEM_ITEMS_VL

308: IF (scope = 2 OR scope = 3) THEN
309: BEGIN
310: SELECT concatenated_segments, DESCRIPTION
311: INTO l_assy_item_name, l_item_desc
312: FROM MTL_SYSTEM_ITEMS_VL
313: WHERE organization_id = t_org_code_list(I)
314: AND inventory_item_id = common_item_from ;
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN