APPS.BOM_REVISIONS dependencies on MTL_SYSTEM_ITEMS_VL

Line 885: l_item_name MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;

881: )
882: IS
883: stmt_num INTEGER;
884: l_rev_date DATE;
885: l_item_name MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;
886:
887: BEGIN
888: IF (type = 'PART') THEN
889: IF (eco_status = 'EXCLUDE_HOLD' OR

Line 1009: FROM MTL_SYSTEM_ITEMS_VL msivl

1005: -- bug:2120090 Raise meaningful error as Revision does not exist.
1006: -- Get the Item Name from Id
1007: SELECT msivl.CONCATENATED_SEGMENTS
1008: INTO l_item_name
1009: FROM MTL_SYSTEM_ITEMS_VL msivl
1010: WHERE msivl.INVENTORY_ITEM_ID = item_id
1011: AND msivl.ORGANIZATION_ID = org_id;
1012:
1013: FND_MESSAGE.SET_NAME('BOM', 'BOM_REVISION_DOESNOT_EXIST');