APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_ATTR_GROUPS_V

Line 887: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;

883:
884: l_attr_group_id NUMBER;
885: l_attr_id NUMBER;
886: l_temp_str VARCHAR2(30); --R12C UOM Changes
887: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
888: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
889:
890: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
891: SELECT attr_group_disp_name

Line 892: FROM ego_attr_groups_v

888: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
889:
890: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
891: SELECT attr_group_disp_name
892: FROM ego_attr_groups_v
893: WHERE attr_group_id = p_attr_group_id;
894:
895: CURSOR c_attr_disp_name(p_attr_id IN NUMBER) IS
896: SELECT attr_display_name

Line 4322: FROM ego_attr_groups_v

4318: -- Fixed in 11.5.10. Ensuring only the Item User-Defined Attrs are processed.
4319: ------------------------------------------------------------------------------
4320: (
4321: SELECT attr_group_id
4322: FROM ego_attr_groups_v
4323: WHERE attr_group_type in (G_IUD_ATTR_GROUP_TYPE, G_GTN_SNG_ATTR_GROUP_TYPE, G_GTN_MUL_ATTR_GROUP_TYPE)
4324: AND application_id = G_APPLICATION_ID
4325: )
4326: ;

Line 5278: FROM EGO_ATTR_GROUPS_V

5274: -- Following statement fetches the Attribute Group Id --
5275: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
5276: (
5277: SELECT ATTR_GROUP_ID
5278: FROM EGO_ATTR_GROUPS_V
5279: WHERE ATTR_GROUP_TYPE = G_ERP_ATTR_GROUP_TYPE
5280: AND APPLICATION_ID = G_APPLICATION_ID
5281: );
5282:

Line 5295: FROM EGO_ATTR_GROUPS_V

5291: -- Following statement fetches the Attribute Group Id --
5292: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
5293: (
5294: SELECT ATTR_GROUP_ID
5295: FROM EGO_ATTR_GROUPS_V
5296: WHERE ATTR_GROUP_TYPE = G_ERP_ATTR_GROUP_TYPE
5297: AND APPLICATION_ID = G_APPLICATION_ID
5298: );
5299: