DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_ATTR_GROUPS_V

Line 1040: FROM EGO_ATTR_GROUPS_V

1036: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1037:
1038: DELETE FROM EGO_ATTR_GROUP_DL
1039: WHERE ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1040: FROM EGO_ATTR_GROUPS_V
1041: WHERE APPLICATION_ID = p_application_id
1042: AND ATTR_GROUP_TYPE = p_attr_group_type
1043: AND ATTR_GROUP_NAME = p_attr_group_name);
1044:

Line 9330: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;

9326:
9327: --Checking if the variant attribute group trying to be associated has attributes in it, if not raise exception
9328: SELECT Nvl(VARIANT, 'N')
9329: INTO l_variant_flag
9330: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
9331:
9332: SELECT Count(1)
9333: INTO l_attr_count
9334: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

Line 9334: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

9330: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
9331:
9332: SELECT Count(1)
9333: INTO l_attr_count
9334: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV
9335: WHERE AGV.APPLICATION_ID = AV.APPLICATION_ID
9336: AND AGV.ATTR_GROUP_TYPE = AV.ATTR_GROUP_TYPE
9337: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
9338: AND AGV.ATTR_GROUP_ID = p_attr_group_id;

Line 9357: FROM EGO_ATTR_GROUPS_V AGV

9353: WHERE OBJECT_ID = p_object_id
9354: AND CLASSIFICATION_CODE = p_classification_code
9355: AND VARIANT = 'Y'
9356: AND EXISTS (SELECT 'X'
9357: FROM EGO_ATTR_GROUPS_V AGV
9358: WHERE AGV.ATTR_GROUP_ID = p_attr_group_id
9359: AND AGV.VARIANT = 'Y');
9360:
9361: -- special handling for variant attribute groups

Line 15626: FROM EGO_ATTR_GROUPS_V AGV

15622: MA.MAPPED_UOM_PARAMETER MAPPED_UOM_PARAMETER,
15623: MA.VALUE_UOM_SOURCE VALUE_UOM_SOURCE,
15624: MA.FIXED_UOM FIXED_UOM,
15625: (SELECT AGV.ATTR_GROUP_DISP_NAME
15626: FROM EGO_ATTR_GROUPS_V AGV
15627: WHERE AGV.APPLICATION_ID = MA.MAPPED_TO_GROUP_PK1
15628: AND AGV.ATTR_GROUP_TYPE = MA.MAPPED_TO_GROUP_PK2
15629: AND AGV.ATTR_GROUP_NAME = MA.MAPPED_TO_GROUP_PK3) ATTR_GROUP_DISP_NAME,
15630: (SELECT AV.SEQUENCE