DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on FND_OBJECTS

Line 2982: and assocs.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')

2978: into l_zeroeth_assoc_exists
2979: from EGO_FND_DSC_FLX_CTX_EXT ext,
2980: EGO_OBJ_AG_ASSOCS_B assocs
2981: where assocs.classification_code = '-1'
2982: and assocs.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')
2983: and assocs.attr_group_id =ext.attr_group_id
2984: and ext.DESCRIPTIVE_FLEXFIELD_NAME in ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
2985: and ext.application_id = G_EGO_APP_ID
2986: and rownum<2;

Line 3647: AND ASOC.OBJECT_ID = (SELECT OBJECT_ID FROM FND_OBJECTS WHERE OBJ_NAME = 'EGO_ITEM')

3643: WHERE EXT.ATTR_GROUP_ID = ASOC.ATTR_GROUP_ID
3644: AND EXT.APPLICATION_ID = 431
3645: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3646: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
3647: AND ASOC.OBJECT_ID = (SELECT OBJECT_ID FROM FND_OBJECTS WHERE OBJ_NAME = 'EGO_ITEM')
3648: AND ASOC.CLASSIFICATION_CODE = p_catalog_group_id
3649: AND ASOC.ASSOCIATION_ID = PGE.ASSOCIATION_ID
3650: AND ASOC.CLASSIFICATION_CODE = PGE.CLASSIFICATION_CODE
3651: AND PGE.PAGE_ID = PT.PAGE_ID