APPS.EGO_UI_ITEM_PUB dependencies on MTL_ITEM_ATTRIBUTES

Line 476: FROM mtl_item_attributes a

472: WHERE template_id = cp_template_id
473: AND enabled_flag = 'Y'
474: AND attribute_name IN
475: ( SELECT a.attribute_name
476: FROM mtl_item_attributes a
477: WHERE NVL(a.status_control_code, 3) <> 1
478: AND a.control_level IN (1, 2)
479: AND a.attribute_group_id_gui IS NOT NULL
480: AND a.attribute_name NOT IN

Line 503: FROM mtl_item_attributes a

499: WHERE template_id = cp_template_id
500: AND enabled_flag = 'Y'
501: AND attribute_name IN
502: ( SELECT a.attribute_name
503: FROM mtl_item_attributes a
504: WHERE NVL(a.status_control_code, 3) <> 1
505: AND a.control_level IN (1, 2)
506: AND a.attribute_group_id_gui IS NOT NULL
507: AND a.attribute_name IN

Line 1499: FROM MTL_ITEM_ATTRIBUTES_V

1495: IS
1496: L_CONTROL_LEVEL NUMBER;
1497: BEGIN
1498: SELECT LOOKUP_CODE2 INTO L_CONTROL_LEVEL
1499: FROM MTL_ITEM_ATTRIBUTES_V
1500: WHERE ATTRIBUTE_NAME = P_ITEM_ATTRIBUTE;
1501:
1502: RETURN L_CONTROL_LEVEL;
1503: END Get_Item_Attr_Control_Level;