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_COND_STRUCT_RESTRICT_VALUE

Line 1487: AMS_COND_STRUCT_RESTRICT_VALUE res_values

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
1491: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id(+)

Line 1497: AMS_COND_STRUCT_RESTRICT_VALUE res_values

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
1501: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id

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 1817: AMS_COND_STRUCT_RESTRICT_VALUE res_values

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
1821: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id

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)