DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREAS_EXT_VL

Line 1090: from rrs_trade_areas_ext_vl a,rrs_trade_areas b

1086: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1087: AND eoab.attr_group_id = ext.attr_group_id
1088: AND eoab.classification_code IN
1089: ( select b.group_id
1090: from rrs_trade_areas_ext_vl a,rrs_trade_areas b
1091: where b.location_id = l_location_id
1092: and a.trade_area_id = b.trade_area_id
1093: );
1094:

Line 1116: from rrs_trade_areas_ext_vl a

1112: AND DISPLAY_NAME = p_page_name
1113: AND CLASSIFICATION_CODE IN
1114: (
1115: select b.group_id
1116: from rrs_trade_areas_ext_vl a
1117: ,rrs_trade_areas b
1118: where b.location_id = l_location_id
1119: and a.trade_area_id = b.trade_area_id
1120: )