APPS.EGO_GTIN_PVT dependencies on EGO_ATTRS_V

Line 2449: FROM ego_attrs_v v

2445:
2446: CURSOR c_user_attr_metadata IS
2447: SELECT data_type_code
2448: , database_column
2449: FROM ego_attrs_v v
2450: WHERE attr_group_type = p_attr_group_type
2451: AND attr_group_name = p_attr_group_name
2452: AND attr_name = p_attr_name
2453: AND application_id = 431;

Line 5070: FROM EGO_ATTRS_V

5066: x_msg_data OUT NOCOPY VARCHAR2)
5067: IS
5068: CURSOR c_single_attrs_not_upd IS
5069: SELECT DATA_TYPE_CODE, DATABASE_COLUMN
5070: FROM EGO_ATTRS_V
5071: WHERE ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
5072: AND APPLICATION_ID = 431
5073: AND EDIT_IN_HIERARCHY_CODE LIKE 'L%'
5074: AND NVL(ENABLED_FLAG, 'N') = 'Y';

Line 5118: FROM EGO_FND_DSC_FLX_CTX_EXT AG, EGO_ATTRS_V EAV

5114: DELETE FROM EGO_ITM_GTN_MUL_ATTRS_B
5115: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
5116: AND ORGANIZATION_ID = p_organization_id
5117: AND ATTR_GROUP_ID IN (SELECT AG.ATTR_GROUP_ID
5118: FROM EGO_FND_DSC_FLX_CTX_EXT AG, EGO_ATTRS_V EAV
5119: WHERE AG.APPLICATION_ID = 431
5120: AND EAV.APPLICATION_ID = AG.APPLICATION_ID
5121: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = EAV.ATTR_GROUP_TYPE
5122: AND AG.DESCRIPTIVE_FLEX_CONTEXT_CODE = EAV.ATTR_GROUP_NAME