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_LIST_SRC_FIELDS

Line 250: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,

246: cursor c_index_columns is
247: select column_name from sys.all_tab_columns where table_name = l_view_name
248: and column_name not in (
249: select flds.source_column_name
250: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
251: ams_query_template_all qtemp
252: where alias.template_id = p_template_id
253: and alias.object_name = types.source_type_code
254: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

Line 305: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,

301:
302: /*
303: cursor c_master_columns is
304: select flds.source_column_name
305: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
306: ams_query_template_all qtemp
307: where alias.template_id = p_template_id
308: and alias.object_name = types.source_type_code
309: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

Line 319: --from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,

315: -- SOLIN, select primary key only to save table space
316: -- In preview entries, it will join master data source.
317: cursor c_master_columns is
318: --select flds.source_column_name
319: --from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
320: -- ams_query_template_all qtemp
321: --where alias.template_id = p_template_id
322: -- and alias.object_name = types.source_type_code
323: -- and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

Line 1534: from ams_list_src_fields flds,ams_attb_lov_b lovb, ams_list_queries_all qu

1530:
1531:
1532: cursor c_lov_sql (l_list_source_type_id NUMBER,l_source_field varchar2) is
1533: select qu.QUERY --sql_string is obsolete bug 4604653
1534: from ams_list_src_fields flds,ams_attb_lov_b lovb, ams_list_queries_all qu
1535: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1536: and flds.SOURCE_COLUMN_NAME = l_source_field
1537: and flds.attb_lov_id = lovb.attb_lov_id
1538: and lovb.CREATION_TYPE = 'SQL'

Line 1550: from ams_list_src_fields flds ,ams_attb_lov_b lovb

1546: l_object_alias varchar2(30);
1547:
1548: cursor c_lov_type (l_list_source_type_id NUMBER,l_source_field varchar2) is
1549: select lovb.CREATION_TYPE
1550: from ams_list_src_fields flds ,ams_attb_lov_b lovb
1551: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1552: and flds.SOURCE_COLUMN_NAME = l_source_field
1553: and flds.attb_lov_id = lovb.attb_lov_id;
1554: l_lov_type varchar2(60);

Line 1559: from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb

1555:
1556:
1557: cursor c_lov_user (l_list_source_type_id NUMBER,l_source_field varchar2) is
1558: select valb.value_code
1559: from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb
1560: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1561: and flds.SOURCE_COLUMN_NAME = l_source_field
1562: and flds.attb_lov_id = lovb.attb_lov_id
1563: and lovb.CREATION_TYPE = 'USER'

Line 1699: ' from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb'||

1695: Ams_Utility_Pvt.Write_Conc_log(' (l_left_operand_rec.list_source_type_id = '||l_left_operand_rec.list_source_type_id);
1696: Ams_Utility_Pvt.Write_Conc_log(' (l_left_operand_rec.attr_name = '||l_left_operand_rec.attr_name);
1697:
1698: EXECUTE IMMEDIATE ' BEGIN select valb.value_code '||' BULK COLLECT INTO :1 '||
1699: ' from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb'||
1700: ' where flds.LIST_SOURCE_TYPE_ID = :2'||
1701: ' and flds.SOURCE_COLUMN_NAME = :3 '||
1702: ' and flds.attb_lov_id = lovb.attb_lov_id and lovb.CREATION_TYPE = '||''''|| 'USER'||''''||
1703: ' and lovb.attb_lov_id = valb.attb_lov_id ; END; ' USING OUT l_code_tbl, IN l_left_operand_rec.list_source_type_id, l_left_operand_rec.attr_name;