APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_ATTR_GROUPS_V

Line 924: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;

920:
921: l_attr_group_id NUMBER;
922: l_attr_id NUMBER;
923: l_temp_str VARCHAR2(30); --R12C UOM Changes
924: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
925: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
926:
927: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
928: SELECT attr_group_disp_name

Line 929: FROM ego_attr_groups_v

925: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
926:
927: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
928: SELECT attr_group_disp_name
929: FROM ego_attr_groups_v
930: WHERE attr_group_id = p_attr_group_id;
931:
932: CURSOR c_attr_disp_name(p_attr_id IN NUMBER) IS
933: SELECT attr_display_name

Line 4407: FROM ego_attr_groups_v

4403: -- Fixed in 11.5.10. Ensuring only the Item User-Defined Attrs are processed.
4404: ------------------------------------------------------------------------------
4405: (
4406: SELECT attr_group_id
4407: FROM ego_attr_groups_v
4408: WHERE attr_group_type in (G_IUD_ATTR_GROUP_TYPE, G_GTN_SNG_ATTR_GROUP_TYPE, G_GTN_MUL_ATTR_GROUP_TYPE)
4409: AND application_id = G_APPLICATION_ID
4410: )
4411: ;

Line 5368: FROM EGO_ATTR_GROUPS_V

5364: -- Following statement fetches the Attribute Group Id --
5365: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
5366: (
5367: SELECT ATTR_GROUP_ID
5368: FROM EGO_ATTR_GROUPS_V
5369: WHERE ATTR_GROUP_TYPE = G_ERP_ATTR_GROUP_TYPE
5370: AND APPLICATION_ID = G_APPLICATION_ID
5371: );
5372:

Line 5385: FROM EGO_ATTR_GROUPS_V

5381: -- Following statement fetches the Attribute Group Id --
5382: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
5383: (
5384: SELECT ATTR_GROUP_ID
5385: FROM EGO_ATTR_GROUPS_V
5386: WHERE ATTR_GROUP_TYPE = G_ERP_ATTR_GROUP_TYPE
5387: AND APPLICATION_ID = G_APPLICATION_ID
5388: );
5389: