APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_QUERY_COND_DISP_STRUCT_VL

Line 173: from AMS_QUERY_COND_DISP_STRUCT_vl

169: l_remote_truncate_string VARCHAR2(32767);
170:
171: cursor c_attributes is
172: SELECT distinct non_variant_value, query_alias_id
173: from AMS_QUERY_COND_DISP_STRUCT_vl
174: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
175: and query_alias_id is not null;
176:
177: cursor c_total_attributes is

Line 179: from AMS_QUERY_COND_DISP_STRUCT_vl

175: and query_alias_id is not null;
176:
177: cursor c_total_attributes is
178: select count(*) from (SELECT distinct non_variant_value, query_alias_id
179: from AMS_QUERY_COND_DISP_STRUCT_vl
180: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
181: and query_alias_id is not null) total_records;
182:
183: cursor c_attributes_alias is

Line 188: from AMS_QUERY_COND_DISP_STRUCT_vl

184: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
185: alias2.line_num
186: from
187: (SELECT distinct non_variant_value, query_alias_id
188: from AMS_QUERY_COND_DISP_STRUCT_vl
189: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
190: and query_alias_id is not null) alias1,
191: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
192: 'A'||to_char(rownum) line_num

Line 205: from AMS_QUERY_COND_DISP_STRUCT_vl

201: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
202: alias2.line_num
203: from
204: (SELECT distinct non_variant_value, query_alias_id
205: from AMS_QUERY_COND_DISP_STRUCT_vl
206: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
207: and query_alias_id is not null) alias1,
208: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
209: 'A'||to_char(rownum) line_num

Line 224: from AMS_QUERY_COND_DISP_STRUCT_vl

220: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
221: alias2.line_num
222: from
223: (SELECT distinct non_variant_value, query_alias_id
224: from AMS_QUERY_COND_DISP_STRUCT_vl
225: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
226: and query_alias_id is not null) alias1,
227: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
228: 'A'||to_char(rownum) line_num

Line 253: from AMS_QUERY_COND_DISP_STRUCT_vl

249: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
250: alias2.line_num
251: from
252: (SELECT distinct non_variant_value, query_alias_id
253: from AMS_QUERY_COND_DISP_STRUCT_vl
254: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
255: and query_alias_id is not null) alias1,
256: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
257: 'A'||to_char(rownum) line_num

Line 311: from AMS_QUERY_COND_DISP_STRUCT_vl

307: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
308: alias2.line_num
309: from
310: (SELECT distinct non_variant_value, query_alias_id
311: from AMS_QUERY_COND_DISP_STRUCT_vl
312: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
313: and query_alias_id is not null) alias1,
314: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
315: 'A'||to_char(rownum) line_num

Line 366: from AMS_QUERY_COND_DISP_STRUCT_vl

362: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
363: alias2.line_num, alias2.list_source_type_id
364: from
365: (SELECT distinct non_variant_value, query_alias_id
366: from AMS_QUERY_COND_DISP_STRUCT_vl
367: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
368: and query_alias_id is not null) alias1,
369: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
370: 'A'||to_char(rownum) line_num,types.list_source_type_id

Line 1637: from AMS_QUERY_COND_DISP_STRUCT_vl

1633: cursor c_alias is
1634: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.line_num
1635: from
1636: (SELECT distinct non_variant_value, query_alias_id
1637: from AMS_QUERY_COND_DISP_STRUCT_vl
1638: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
1639: and query_alias_id is not null) alias1,
1640: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
1641: 'A'||to_char(rownum) line_num

Line 1915: from AMS_QUERY_COND_DISP_STRUCT_vl struct

1911:
1912: --Values
1913: CURSOR C_display_values(p_query_cond_id NUMBER) IS
1914: select display_text
1915: from AMS_QUERY_COND_DISP_STRUCT_vl struct
1916: where struct.query_condition_id = p_query_cond_id and
1917: struct.token_type in ('VALUE1');
1918:
1919: CURSOR C_display_value2(p_query_cond_id NUMBER) IS

Line 1921: from AMS_QUERY_COND_DISP_STRUCT_vl struct

1917: struct.token_type in ('VALUE1');
1918:
1919: CURSOR C_display_value2(p_query_cond_id NUMBER) IS
1920: select display_text
1921: from AMS_QUERY_COND_DISP_STRUCT_vl struct
1922: where struct.query_condition_id = p_query_cond_id and
1923: struct.token_type in ('VALUE2');
1924:
1925: --Alias

Line 1930: from AMS_QUERY_COND_DISP_STRUCT_vl

1926: CURSOR C_alias(p_template_id NUMBER) IS
1927: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.line_num
1928: from
1929: (SELECT distinct non_variant_value, query_alias_id
1930: from AMS_QUERY_COND_DISP_STRUCT_vl
1931: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
1932: and query_alias_id is not null) alias1,
1933: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
1934: 'A'||to_char(rownum) line_num