[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT geography_id
INTO x_zone_geography_id
FROM hz_geographies
WHERE geography_type = p_zone_type
AND geography_name = l_zone_name;
SELECT segment_attribute_type
FROM fnd_segment_attribute_values seg, ar_system_parameters_all sys
WHERE seg.id_flex_code = 'RLOC'
AND seg.id_flex_num = sys.location_structure_id
AND seg.attribute_value = 'Y'
AND segment_attribute_type NOT IN ('TAX_ACCOUNT', 'EXEMPT_LEVEL')
GROUP BY segment_attribute_type;
SELECT sys.location_structure_id,
SUBSTRB(sys.default_country,1, 2) default_country,
attr.segment_attribute_type,
geo.geography_id
BULK COLLECT INTO
l_location_structure_id_tbl, l_country_code_tbl,
l_segment_attribute_type_tbl, l_geography_id_tbl
FROM fnd_id_flex_structures struct, fnd_id_flex_segments_vl seg, fnd_segment_attribute_values attr,
ar_system_parameters_all sys, hz_geographies geo
WHERE struct.application_id = seg.application_id
AND struct.id_flex_code = seg.id_flex_code
AND struct.id_flex_num = seg.id_flex_num
AND struct.freeze_flex_definition_flag = 'Y'
AND struct.enabled_flag = 'Y'
AND seg.application_id = attr.application_id
AND seg.id_flex_code = attr.id_flex_code
AND seg.id_flex_num = attr.id_flex_num
AND seg.application_column_name = attr.application_column_name
AND seg.id_flex_num = sys.location_structure_id
AND seg.id_flex_code = 'RLOC'
AND seg.enabled_flag = 'Y'
AND segment_attribute_type NOT IN ('TAX_ACCOUNT', 'EXEMPT_LEVEL')
AND attr.attribute_value = 'Y'
AND sys.default_country = geo.country_code
AND geo.geography_type = 'COUNTRY'
GROUP BY sys.location_structure_id, sys.default_country,
segment_attribute_type, geo.geography_id
ORDER BY sys.location_structure_id, sys.default_country,
segment_attribute_type, geo.geography_id;
l_incl_geo_type.delete;