DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 327: FROM mtl_system_items_kfv

323: number_value := to_number(SUBSTR(context, 1, (INSTR(context, '+-?*', 1, 1)-1)));
324:
325: ELSIF attr_name = 'ITEM_NUMBER' THEN
326: SELECT concatenated_segments INTO text_value
327: FROM mtl_system_items_kfv
328: WHERE to_char(organization_id) = SUBSTR(context, 1, (INSTR(context, '+-?*', 1, 1)-1))
329: AND to_char(inventory_item_id) = SUBSTR(context, (INSTR(context, '+-?*', 1, 1)+4), INSTR(context, '+-?*', 1, 2) - (INSTR(context, '+-?*', 1, 1)+4));
330:
331: ELSIF attr_name = 'ITEM_ID' THEN