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.

[Home] [Help]

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_LIST_SRC_FIELDS

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

267: cursor c_index_columns is
268: select column_name from sys.all_tab_columns where table_name = l_view_name
269: and column_name not in (
270: select flds.source_column_name
271: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
272: ams_query_template_all qtemp
273: where alias.template_id = p_template_id
274: and alias.object_name = types.source_type_code
275: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

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

322:
323: /*
324: cursor c_master_columns is
325: select flds.source_column_name
326: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
327: ams_query_template_all qtemp
328: where alias.template_id = p_template_id
329: and alias.object_name = types.source_type_code
330: and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

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

336: -- SOLIN, select primary key only to save table space
337: -- In preview entries, it will join master data source.
338: cursor c_master_columns is
339: --select flds.source_column_name
340: --from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
341: -- ams_query_template_all qtemp
342: --where alias.template_id = p_template_id
343: -- and alias.object_name = types.source_type_code
344: -- and types.LIST_SOURCE_TYPE_ID = flds.LIST_SOURCE_TYPE_ID

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

1596:
1597:
1598: cursor c_lov_sql (l_list_source_type_id NUMBER,l_source_field varchar2) is
1599: select qu.QUERY --sql_string is obsolete bug 4604653
1600: from ams_list_src_fields flds,ams_attb_lov_b lovb, ams_list_queries_all qu
1601: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1602: and flds.SOURCE_COLUMN_NAME = l_source_field
1603: and flds.attb_lov_id = lovb.attb_lov_id
1604: and lovb.CREATION_TYPE = 'SQL'

Line 1616: from ams_list_src_fields flds ,ams_attb_lov_b lovb

1612: l_object_alias varchar2(30);
1613:
1614: cursor c_lov_type (l_list_source_type_id NUMBER,l_source_field varchar2) is
1615: select lovb.CREATION_TYPE
1616: from ams_list_src_fields flds ,ams_attb_lov_b lovb
1617: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1618: and flds.SOURCE_COLUMN_NAME = l_source_field
1619: and flds.attb_lov_id = lovb.attb_lov_id;
1620: l_lov_type varchar2(60);

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

1621:
1622:
1623: cursor c_lov_user (l_list_source_type_id NUMBER,l_source_field varchar2) is
1624: select valb.value_code
1625: from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb
1626: where flds.LIST_SOURCE_TYPE_ID = l_list_source_type_id
1627: and flds.SOURCE_COLUMN_NAME = l_source_field
1628: and flds.attb_lov_id = lovb.attb_lov_id
1629: and lovb.CREATION_TYPE = 'USER'

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

1761: Ams_Utility_Pvt.Write_Conc_log(' (l_left_operand_rec.list_source_type_id = '||l_left_operand_rec.list_source_type_id);
1762: Ams_Utility_Pvt.Write_Conc_log(' (l_left_operand_rec.attr_name = '||l_left_operand_rec.attr_name);
1763:
1764: EXECUTE IMMEDIATE ' BEGIN select valb.value_code '||' BULK COLLECT INTO :1 '||
1765: ' from ams_list_src_fields flds ,ams_attb_lov_b lovb, ams_attb_lov_values_b valb'||
1766: ' where flds.LIST_SOURCE_TYPE_ID = :2'||
1767: ' and flds.SOURCE_COLUMN_NAME = :3 '||
1768: ' and flds.attb_lov_id = lovb.attb_lov_id and lovb.CREATION_TYPE = '||''''|| 'USER'||''''||
1769: ' 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;