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_CONDITION

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 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