APPS.EGO_ITEM_WS_PVT dependencies on EGO_VALUE_SET_VALUES_V

Line 623: ego_attrs_v eav, EGO_VALUE_SET_VALUES_V evsv

619: null as TRANSLATED_CHAR_VALUE,
620: REVISION_ID
621: FROM ego_all_attr_base_v)
622: ) list , EGO_PUB_WS_FLAT_RECS flat ,
623: ego_attrs_v eav, EGO_VALUE_SET_VALUES_V evsv
624: WHERE
625: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
626: AND list.EXTENSION_ID = FLAT.REF2_VALUE
627: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE

Line 782: ) list, EGO_VALUE_SET_VALUES_V evsv

778: AND FLAT.REF3_VALUE = To_Char(dataLevelId)
779: AND FLAT.session_id = sessionId
780: AND FLAT.ENTITY_TYPE = 'ATTRIBUTE_GROUP'
781: AND Nvl(AGC.enabled_flag, 'Y') = 'Y' -- Bug 9542020
782: ) list, EGO_VALUE_SET_VALUES_V evsv
783: WHERE list.VALUE_SET_ID = evsv.VALUE_SET_ID (+)
784: AND
785: (
786: ( list.ATTRIBUTE_CHAR_VALUE IS NOT NULL