APPS.BOM_REVISIONS dependencies on MTL_SYSTEM_ITEMS_VL

Line 876: l_item_name MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;

872: )
873: IS
874: stmt_num INTEGER;
875: l_rev_date DATE;
876: l_item_name MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;
877:
878: BEGIN
879: IF (type = 'PART') THEN
880: IF (eco_status = 'EXCLUDE_HOLD' OR

Line 1000: FROM MTL_SYSTEM_ITEMS_VL msivl

996: -- bug:2120090 Raise meaningful error as Revision does not exist.
997: -- Get the Item Name from Id
998: SELECT msivl.CONCATENATED_SEGMENTS
999: INTO l_item_name
1000: FROM MTL_SYSTEM_ITEMS_VL msivl
1001: WHERE msivl.INVENTORY_ITEM_ID = item_id
1002: AND msivl.ORGANIZATION_ID = org_id;
1003:
1004: FND_MESSAGE.SET_NAME('BOM', 'BOM_REVISION_DOESNOT_EXIST');