APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_QUERY_COND_DISP_STRUCT_VL

Line 152: from AMS_QUERY_COND_DISP_STRUCT_vl

148: l_remote_truncate_string VARCHAR2(32767);
149:
150: cursor c_attributes is
151: SELECT distinct non_variant_value, query_alias_id
152: from AMS_QUERY_COND_DISP_STRUCT_vl
153: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
154: and query_alias_id is not null;
155:
156: cursor c_total_attributes is

Line 158: from AMS_QUERY_COND_DISP_STRUCT_vl

154: and query_alias_id is not null;
155:
156: cursor c_total_attributes is
157: select count(*) from (SELECT distinct non_variant_value, query_alias_id
158: from AMS_QUERY_COND_DISP_STRUCT_vl
159: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
160: and query_alias_id is not null) total_records;
161:
162: cursor c_attributes_alias is

Line 167: from AMS_QUERY_COND_DISP_STRUCT_vl

163: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
164: alias2.line_num
165: from
166: (SELECT distinct non_variant_value, query_alias_id
167: from AMS_QUERY_COND_DISP_STRUCT_vl
168: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
169: and query_alias_id is not null) alias1,
170: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
171: 'A'||to_char(rownum) line_num

Line 184: from AMS_QUERY_COND_DISP_STRUCT_vl

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

Line 203: from AMS_QUERY_COND_DISP_STRUCT_vl

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

Line 232: from AMS_QUERY_COND_DISP_STRUCT_vl

228: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
229: alias2.line_num
230: from
231: (SELECT distinct non_variant_value, query_alias_id
232: from AMS_QUERY_COND_DISP_STRUCT_vl
233: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
234: and query_alias_id is not null) alias1,
235: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
236: 'A'||to_char(rownum) line_num

Line 290: from AMS_QUERY_COND_DISP_STRUCT_vl

286: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
287: alias2.line_num
288: from
289: (SELECT distinct non_variant_value, query_alias_id
290: from AMS_QUERY_COND_DISP_STRUCT_vl
291: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
292: and query_alias_id is not null) alias1,
293: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
294: 'A'||to_char(rownum) line_num

Line 345: from AMS_QUERY_COND_DISP_STRUCT_vl

341: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.master_source_type_flag,alias2.source_object_pk_field,
342: alias2.line_num, alias2.list_source_type_id
343: from
344: (SELECT distinct non_variant_value, query_alias_id
345: from AMS_QUERY_COND_DISP_STRUCT_vl
346: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
347: and query_alias_id is not null) alias1,
348: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
349: 'A'||to_char(rownum) line_num,types.list_source_type_id

Line 1571: from AMS_QUERY_COND_DISP_STRUCT_vl

1567: cursor c_alias is
1568: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.line_num
1569: from
1570: (SELECT distinct non_variant_value, query_alias_id
1571: from AMS_QUERY_COND_DISP_STRUCT_vl
1572: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
1573: and query_alias_id is not null) alias1,
1574: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
1575: 'A'||to_char(rownum) line_num

Line 1849: from AMS_QUERY_COND_DISP_STRUCT_vl struct

1845:
1846: --Values
1847: CURSOR C_display_values(p_query_cond_id NUMBER) IS
1848: select display_text
1849: from AMS_QUERY_COND_DISP_STRUCT_vl struct
1850: where struct.query_condition_id = p_query_cond_id and
1851: struct.token_type in ('VALUE1');
1852:
1853: CURSOR C_display_value2(p_query_cond_id NUMBER) IS

Line 1855: from AMS_QUERY_COND_DISP_STRUCT_vl struct

1851: struct.token_type in ('VALUE1');
1852:
1853: CURSOR C_display_value2(p_query_cond_id NUMBER) IS
1854: select display_text
1855: from AMS_QUERY_COND_DISP_STRUCT_vl struct
1856: where struct.query_condition_id = p_query_cond_id and
1857: struct.token_type in ('VALUE2');
1858:
1859: --Alias

Line 1864: from AMS_QUERY_COND_DISP_STRUCT_vl

1860: CURSOR C_alias(p_template_id NUMBER) IS
1861: select distinct alias2.query_alias_id,alias2.source_object_name, alias2.line_num
1862: from
1863: (SELECT distinct non_variant_value, query_alias_id
1864: from AMS_QUERY_COND_DISP_STRUCT_vl
1865: where query_template_id = p_template_id and token_type in ('ATTRIBUTE','VALUE1','VALUE2')
1866: and query_alias_id is not null) alias1,
1867: (select alias.query_alias_id, types.source_object_name, types.master_source_type_flag,types.source_object_pk_field,
1868: 'A'||to_char(rownum) line_num