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.IEX_STRY_UTL_PUB dependencies on DUAL

Line 1011: select sysdate into r_date from dual; -- default to sysdate;

1007: l_conversion number := 0;
1008: l_jtf_time_uom_class varchar2(255); --Added for Bug 7434190 22-Jan-2009 barathsr
1009: begin
1010:
1011: select sysdate into r_date from dual; -- default to sysdate;
1012:
1013: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1014: iex_debug_pub.logmessage ('get_date before get conversion rate ');
1015: END IF;

Line 1020: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */

1016: --Start of bug 7434190 22-Jan-2009 barathsr
1017: l_jtf_time_uom_class := fnd_profile.value_specific(NAME => 'JTF_TIME_UOM_CLASS',APPLICATION_ID =>695);
1018: select conversion_rate into l_conversion from mtl_uom_conversions
1019: --Use the profile 'unit of measure class' value if it is set at application level, else use it from site level
1020: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */
1021: where UOM_code = l_UOM and uom_class = l_jtf_time_uom_class
1022: --End of Bug 7434190 22-Jan-2009 barathsr
1023: and inventory_item_id = 0;
1024: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1028: select p_date + l_conversion * l_unit / 24 into r_date from dual;

1024: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1025: iex_debug_pub.logmessage ('get_date l_conversion => '|| l_conversion);
1026: END IF;
1027:
1028: select p_date + l_conversion * l_unit / 24 into r_date from dual;
1029: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1030: iex_debug_pub.logmessage ('get_date => '|| to_char(r_date, 'yyyy/mm/dd/hh24:mi:ss'));
1031: END IF;
1032: