DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_PKG dependencies on MTL_CATEGORIES_V

Line 336: FROM mtl_categories_v

332: number_value := TO_NUMBER(SUBSTR(context, (INSTR(context, '+-?*', 1, 1)+4), INSTR(context, '+-?*', 1, 2) - (INSTR(context, '+-?*', 1, 1)+4)));
333:
334: ELSIF attr_name = 'ITEM_CATEGORY' THEN
335: SELECT category_concat_segs INTO text_value
336: FROM mtl_categories_v
337: WHERE to_char(category_id) = SUBSTR(context, (INSTR(context, '+-?*', 1, 2)+4), INSTR(context, '+-?*', 1, 3) - (INSTR(context, '+-?*', 1, 2)+4));
338:
339: ELSIF attr_name = 'CATEGORY_ID' THEN
340: number_value := TO_NUMBER(SUBSTR(context, (INSTR(context, '+-?*', 1, 2)+4), INSTR(context, '+-?*', 1, 3) - (INSTR(context, '+-?*', 1, 2)+4)));