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

1549:
1550: cursor c_qualify_conds is
1551: select distinct cond.query_condition_id cond_id
1552: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1553: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1554: where cond.template_id = p_template_id
1555: and cond.value1_type = 'LOV'
1556: and struct.QUERY_CONDITION_ID = cond.query_condition_id
1557: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id(+)

Line 1563: AMS_COND_STRUCT_RESTRICT_VALUE res_values

1559: and cond.mandatory_flag = 'Y'
1560: UNION
1561: select distinct cond.query_condition_id cond_id
1562: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1563: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1564: where cond.template_id = p_template_id
1565: and cond.value1_type = 'LOV'
1566: and struct.QUERY_CONDITION_ID = cond.query_condition_id
1567: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id

Line 1585: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1581: and alias.query_alias_id = struct.query_alias_id
1582: and alias.OBJECT_NAME = src_types.SOURCE_TYPE_CODE;
1583: cursor c_operator (p_cond_id NUMBER) is
1584: select upper(res_values.code) operator
1585: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1586: where struct.query_condition_id = p_cond_id and
1587: struct.token_type = 'OPERATOR'
1588: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1589:

Line 1592: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1588: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1589:
1590: cursor c_lov_values (p_cond_id NUMBER) is
1591: select upper(res_values.code) lov_value
1592: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1593: where struct.query_condition_id = p_cond_id and
1594: struct.token_type = 'VALUE1'
1595: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id;
1596:

Line 1883: AMS_COND_STRUCT_RESTRICT_VALUE res_values

1879: --Query conditions
1880: CURSOR C_query_cond_main IS
1881: select cond.query_condition_id cond_id, count(*)
1882: from AMS_QUERY_CONDITION cond, AMS_QUERY_COND_DISP_STRUCT_all struct,
1883: AMS_COND_STRUCT_RESTRICT_VALUE res_values
1884: where cond.template_id = p_template_id
1885: and cond.value1_type = 'CONSTANT'
1886: and struct.QUERY_CONDITION_ID = cond.query_condition_id
1887: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id

Line 1905: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values

1901:
1902: --Operator
1903: CURSOR C_operator(p_query_cond_id NUMBER) IS
1904: select upper(res_values.code) operator, count(*)
1905: from AMS_QUERY_COND_DISP_STRUCT_all struct, AMS_COND_STRUCT_RESTRICT_VALUE res_values
1906: where struct.query_condition_id = p_query_cond_id and
1907: struct.token_type = 'OPERATOR'
1908: and struct.QUERY_COND_DISP_STRUCT_ID = res_values.query_cond_disp_struct_id
1909: group by upper(res_values.code)