DBA Data[Home] [Help]

APPS.EGO_DEMO_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 272: l_style_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

268: l_style_item_id NUMBER;
269: l_icc_id NUMBER;
270: l_item_type VARCHAR2(1000);
271: l_ego_col_name_value_pair_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
272: l_style_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
273: BEGIN
274: SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL
275: INTO l_item_squence
276: FROM DUAL;

Line 295: FROM MTL_SYSTEM_ITEMS_KFV

291:
292: IF l_style_item_id IS NOT NULL THEN
293: BEGIN
294: SELECT SUBSTR(CONCATENATED_SEGMENTS, 1, 20) INTO l_style_item_num
295: FROM MTL_SYSTEM_ITEMS_KFV
296: WHERE INVENTORY_ITEM_ID = l_style_item_id
297: AND ROWNUM = 1;
298: EXCEPTION WHEN OTHERS THEN
299: l_style_item_num := 'EXCEPTION';