APPS.EGO_GTIN_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 2878: EGO_OBJ_AG_ASSOCS_B A,

2874: BEGIN
2875:
2876: SELECT 'X' into l_temp
2877: FROM
2878: EGO_OBJ_AG_ASSOCS_B A,
2879: EGO_FND_DSC_FLX_CTX_EXT EXT
2880: WHERE
2881: A.ATTR_GROUP_ID = EXT.ATTR_GROUP_ID
2882: AND EXT.APPLICATION_ID = p_application_id

Line 2980: EGO_OBJ_AG_ASSOCS_B assocs

2976: --dbms_output.put_line('in run11 ');
2977: select 1
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')

Line 3183: FROM ego_obj_ag_assocs_b oa,

3179: FROM mtl_item_catalog_groups_b mi
3180: WHERE mi.parent_catalog_group_id IS NULL
3181: AND NOT EXISTS
3182: (SELECT oa.attr_group_id
3183: FROM ego_obj_ag_assocs_b oa,
3184: ego_attr_groups_v eag
3185: WHERE oa.classification_code = mi.item_catalog_group_id
3186: AND oa.attr_group_id = eag.attr_group_id
3187: AND eag.attr_group_type IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS'));

Line 3380: INSERT INTO EGO_OBJ_AG_ASSOCS_B

3376: --dbms_output.put_line('after inserting tl pages');
3377: -- Create Page Association
3378: -- For each (total 15) attribute group create an association with the current catalog group.
3379: FORALL i IN l_AttrGroupIds.FIRST..l_AttrGroupIds.LAST
3380: INSERT INTO EGO_OBJ_AG_ASSOCS_B
3381: (
3382: ASSOCIATION_ID
3383: ,OBJECT_ID
3384: ,CLASSIFICATION_CODE

Line 3429: FROM EGO_OBJ_AG_ASSOCS_B

3425: --dbms_output.put_line('after getting attr grp id list ' || l_attr_grp_id_list);
3426:
3427: SELECT ASSOCIATION_ID -- , ATTR_GROUP_ID
3428: BULK COLLECT INTO l_AssocIds --, l_AttrGroupIds
3429: FROM EGO_OBJ_AG_ASSOCS_B
3430: WHERE OBJECT_ID = l_object_id
3431: AND CLASSIFICATION_CODE = l_classification_code
3432: and ATTR_GROUP_ID in (SELECT ATTR_GROUP_ID FROM EGO_FND_DSC_FLX_CTX_EXT
3433: WHERE DESCRIPTIVE_FLEXFIELD_NAME in ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')

Line 3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT

3638: l_page_disp_name VARCHAR2(4000);
3639: BEGIN
3640: SELECT PT.PAGE_ID, PT.DISPLAY_NAME
3641: INTO l_page_id, l_page_disp_name
3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT
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