DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_ATTRIBUTES

Line 2555: FROM mtl_item_attributes a

2551: WHERE template_id = cp_template_id
2552: AND enabled_flag = 'Y'
2553: AND attribute_name IN
2554: ( SELECT a.attribute_name
2555: FROM mtl_item_attributes a
2556: WHERE NVL(a.status_control_code, 3) <> 1
2557: AND a.control_level IN (1, 2)
2558: AND a.attribute_group_id_gui IS NOT NULL
2559: AND a.attribute_name NOT IN

Line 2581: FROM mtl_item_attributes a

2577: WHERE template_id = cp_template_id
2578: AND enabled_flag = 'Y'
2579: AND attribute_name IN
2580: ( SELECT a.attribute_name
2581: FROM mtl_item_attributes a
2582: WHERE NVL(a.status_control_code, 3) <> 1
2583: AND a.control_level IN (1, 2)
2584: AND a.attribute_group_id_gui IS NOT NULL
2585: AND a.attribute_name IN

Line 3655: FROM MTL_ITEM_ATTRIBUTES_V

3651: FUNCTION Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE IN VARCHAR2) RETURN NUMBER IS
3652: L_CONTROL_LEVEL NUMBER;
3653: BEGIN
3654: SELECT LOOKUP_CODE2 INTO L_CONTROL_LEVEL
3655: FROM MTL_ITEM_ATTRIBUTES_V
3656: WHERE ATTRIBUTE_NAME = P_ITEM_ATTRIBUTE;
3657:
3658: RETURN L_CONTROL_LEVEL;
3659: