APPS.RRS_SITE_INFO dependencies on EGO_OBJ_AG_ASSOCS_B

Line 536: attr_grp_id ego_obj_ag_assocs_b.attr_grp_id%Type

532: l_display_name varchar2(240);
533:
534: -- l_attributes_row_table x_attributes_row_table;
535: /*Type site_entity_rec is Record(
536: attr_grp_id ego_obj_ag_assocs_b.attr_grp_id%Type
537: );
538: Type site_entity_tab is table of site_entity_rec;
539: l_entity_details site_entity_tab;
540: */

Line 588: FROM ego_obj_ag_assocs_b eoab

584:
585: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
586: BULK COLLECT
587: INTO l_attr_grp_name
588: FROM ego_obj_ag_assocs_b eoab
589: ,fnd_objects fo
590: ,EGO_FND_DSC_FLX_CTX_EXT ext
591: WHERE eoab.object_id = fo.object_id
592: AND fo.obj_name in ( 'RRS_SITE')

Line 607: FROM ego_obj_ag_assocs_b eoab

603:
604: SELECT eoab.attr_group_id
605: BULK COLLECT
606: INTO l_attr_grp_id
607: FROM ego_obj_ag_assocs_b eoab
608: ,fnd_objects fo
609: WHERE eoab.object_id = fo.object_id
610: AND fo.obj_name in ( 'RRS_SITE')
611: AND eoab.classification_code IN

Line 859: FROM ego_obj_ag_assocs_b eoab

855:
856: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
857: BULK COLLECT
858: INTO l_attr_grp_name
859: FROM ego_obj_ag_assocs_b eoab
860: ,fnd_objects fo
861: ,EGO_FND_DSC_FLX_CTX_EXT ext
862: WHERE eoab.object_id = fo.object_id
863: AND fo.obj_name in ( 'RRS_LOCATION')

Line 1082: FROM ego_obj_ag_assocs_b eoab

1078:
1079: SELECT distinct ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
1080: BULK COLLECT
1081: INTO l_attr_grp_name
1082: FROM ego_obj_ag_assocs_b eoab
1083: ,fnd_objects fo
1084: ,EGO_FND_DSC_FLX_CTX_EXT ext
1085: WHERE eoab.object_id = fo.object_id
1086: AND fo.obj_name in ( 'RRS_TRADE_AREA')