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_ATTB_LOV_VALUES_B

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;