DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_ATTR_GROUPS_V

Line 2825: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv

2821: l_united_nations_dang_goods_no,
2822: l_flash_point_temp,
2823: l_uom_flash_point_temp,
2824: l_dngr_goods_technical_name
2825: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv
2826: WHERE eigmav.INVENTORY_ITEM_ID = p_inventory_item_id
2827: AND eigmav.ORGANIZATION_ID = p_organization_id
2828: AND eigmav.ATTR_GROUP_ID = eagv.ATTR_GROUP_ID
2829: AND eagv.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'

Line 2997: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv

2993: l_manufacturer_id := NULL;
2994: IF p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN IS NOT NULL THEN
2995: BEGIN
2996: SELECT MANUFACTURER_ID INTO l_manufacturer_id
2997: FROM EGO_ITM_GTN_MUL_ATTRS_VL eigmav, EGO_ATTR_GROUPS_V eagv
2998: WHERE eigmav.INVENTORY_ITEM_ID = p_inventory_item_id
2999: AND eigmav.ORGANIZATION_ID = p_organization_id
3000: AND eigmav.ATTR_GROUP_ID = eagv.ATTR_GROUP_ID
3001: AND eagv.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'