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.CTO_UTILITY_PK dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 3877: from wsh_delivery_details_ob_grp_v wdd -- Modified by Renga on 11/02/03

3873: -- Bugfix 2638216 : added LEAST fn. in case of over-shipping after discussion with Usha and Vidyesh.
3874:
3875: select nvl(sum( LEAST(nvl(wdd.shipped_quantity,0), nvl(wdd.picked_quantity,0)) ), 0)
3876: into l_shipped_qty
3877: from wsh_delivery_details_ob_grp_v wdd -- Modified by Renga on 11/02/03
3878: where wdd.source_line_id = p_order_line_id
3879: and wdd.source_code = 'OE'
3880: and wdd.released_status = 'C' -- Closed [C]
3881: and nvl(wdd.inv_interfaced_flag, 'N') <> 'Y';