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 1005: select sysdate into r_date from dual; -- default to sysdate;

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

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

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

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

1018: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1019: iex_debug_pub.logmessage ('get_date l_conversion => '|| l_conversion);
1020: END IF;
1021:
1022: select p_date + l_conversion * l_unit / 24 into r_date from dual;
1023: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1024: iex_debug_pub.logmessage ('get_date => '|| to_char(r_date, 'yyyy/mm/dd/hh24:mi:ss'));
1025: END IF;
1026: