APPS.BOM_REVISIONS dependencies on MTL_ITEM_FLEXFIELDS

Line 58: FROM MTL_ITEM_FLEXFIELDS

54: part_number VARCHAR2(40);
55: BEGIN
56: SELECT substrb(ITEM_NUMBER, 1, 40)
57: INTO part_number
58: FROM MTL_ITEM_FLEXFIELDS
59: WHERE ORGANIZATION_ID = org_id
60: AND INVENTORY_ITEM_ID = part_id;
61:
62: /*

Line 66: ** ITEM_NUMBER: select from mtl_item_flexfields

62: /*
63: ** return message that is no valid rev for item
64: ** Name: BOM_GET_REV
65: ** EFF_DATE: rev_date
66: ** ITEM_NUMBER: select from mtl_item_flexfields
67: */
68:
69: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV');
70: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', part_number);