eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_ATTRIBUTES

Line 2706: FROM mtl_item_attributes a

2702: WHERE template_id = cp_template_id
2703: AND enabled_flag = 'Y'
2704: AND attribute_name IN
2705: ( SELECT a.attribute_name
2706: FROM mtl_item_attributes a
2707: WHERE NVL(a.status_control_code, 3) <> 1
2708: AND a.control_level IN (1, 2)
2709: AND a.attribute_group_id_gui IS NOT NULL
2710: AND a.attribute_name NOT IN

Line 2732: FROM mtl_item_attributes a

2728: WHERE template_id = cp_template_id
2729: AND enabled_flag = 'Y'
2730: AND attribute_name IN
2731: ( SELECT a.attribute_name
2732: FROM mtl_item_attributes a
2733: WHERE NVL(a.status_control_code, 3) <> 1
2734: AND a.control_level IN (1, 2)
2735: AND a.attribute_group_id_gui IS NOT NULL
2736: AND a.attribute_name IN

Line 3908: FROM MTL_ITEM_ATTRIBUTES_V

3904: FUNCTION Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE IN VARCHAR2) RETURN NUMBER IS
3905: L_CONTROL_LEVEL NUMBER;
3906: BEGIN
3907: SELECT LOOKUP_CODE2 INTO L_CONTROL_LEVEL
3908: FROM MTL_ITEM_ATTRIBUTES_V
3909: WHERE ATTRIBUTE_NAME = P_ITEM_ATTRIBUTE;
3910:
3911: RETURN L_CONTROL_LEVEL;
3912: