eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_QUERY_COND_DISP_STRUCT_ALL

Line 1486: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,

1482: ) IS
1483:
1484: cursor c_qualify_conds is
1485: select distinct cond.query_condition_id cond_id
1486: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1487: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1488: where cond.template_id = p_template_id
1489: and cond.value1_type = 'LOV'
1490: and struct.QUERY_CONDITION_ID = cond.query_condition_id

Line 1496: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,

1492: and struct.token_type= 'OPERATOR'
1493: and cond.mandatory_flag = 'Y'
1494: UNION
1495: select distinct cond.query_condition_id cond_id
1496: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1497: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1498: where cond.template_id = p_template_id
1499: and cond.value1_type = 'LOV'
1500: and struct.QUERY_CONDITION_ID = cond.query_condition_id

Line 1512: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_QUERY_ALIAS alias, ams_list_src_types src_types

1508:
1509: cursor c_left_oprand (p_cond_id NUMBER) is
1510: select struct.non_variant_value attr_name, source_object_name table_name,src_types.list_source_type_id
1511: -- || alias.ALIAS_SEQ table_name
1512: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_QUERY_ALIAS alias, ams_list_src_types src_types
1513: where struct.query_condition_id = p_cond_id
1514: and struct.token_type = 'ATTRIBUTE'
1515: and alias.query_alias_id = struct.query_alias_id
1516: and alias.OBJECT_NAME = src_types.SOURCE_TYPE_CODE;

Line 1519: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1515: and alias.query_alias_id = struct.query_alias_id
1516: and alias.OBJECT_NAME = src_types.SOURCE_TYPE_CODE;
1517: cursor c_operator (p_cond_id NUMBER) is
1518: select upper(res_values.code) operator
1519: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1520: where struct.query_condition_id = p_cond_id and
1521: struct.token_type = 'OPERATOR'
1522: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1523:

Line 1526: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1522: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1523:
1524: cursor c_lov_values (p_cond_id NUMBER) is
1525: select upper(res_values.code) lov_value
1526: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1527: where struct.query_condition_id = p_cond_id and
1528: struct.token_type = 'VALUE1'
1529: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1530:

Line 1816: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,

1812: ) IS
1813: --Query conditions
1814: CURSOR C_query_cond_main IS
1815: select cond.query_condition_id cond_id, count(*)
1816: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1817: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1818: where cond.template_id = p_template_id
1819: and cond.value1_type = 'CONSTANT'
1820: and struct.QUERY_CONDITION_ID = cond.query_condition_id

Line 1830: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_QUERY_ALIAS alias, ams_list_src_types src_types

1826:
1827: --Operand
1828: CURSOR C_left_oprand (p_cond_id NUMBER) IS
1829: select struct.non_variant_value attr_name, source_object_name table_name, src_types.list_source_type_id
1830: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_QUERY_ALIAS alias, ams_list_src_types src_types
1831: where struct.query_condition_id = p_cond_id
1832: and struct.token_type = 'ATTRIBUTE'
1833: and alias.query_alias_id = struct.query_alias_id
1834: and alias.OBJECT_NAME = src_types.SOURCE_TYPE_CODE;

Line 1839: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1835:
1836: --Operator
1837: CURSOR C_operator(p_query_cond_id NUMBER) IS
1838: select upper(res_values.code) operator, count(*)
1839: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1840: where struct.query_condition_id = p_query_cond_id and
1841: struct.token_type = 'OPERATOR'
1842: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id
1843: group by upper(res_values.code)