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.OE_HOLD_SOURCES_PVT dependencies on OE_ORDER_HOLDS

Line 519: UPDATE oe_order_holds_all

515:
516:
517: -- Flag all orders and order line holds for this hold source
518: -- as released
519: UPDATE oe_order_holds_all
520: SET hold_release_id = l_hold_release_id
521: , LAST_UPDATED_BY = l_user_id
522: , LAST_UPDATE_DATE = sysdate
523: WHERE hold_source_id = l_hold_source_id

Line 611: FROM OE_ORDER_HOLDS

607: , HOLD_ENTITY_CODE2
608: , HOLD_ENTITY_ID2
609: FROM OE_HOLD_SOURCES
610: WHERE hold_source_id IN (SELECT hold_source_id
611: FROM OE_ORDER_HOLDS
612: WHERE header_id = p_header_id
613: AND line_id IS NULL
614: AND hold_release_id IS NULL
615: );

Line 693: FROM OE_ORDER_HOLDS

689: , HOLD_ENTITY_CODE2
690: , HOLD_ENTITY_ID2
691: FROM OE_HOLD_SOURCES
692: WHERE hold_source_id IN (SELECT hold_source_id
693: FROM OE_ORDER_HOLDS
694: WHERE line_id = p_line_id
695: AND hold_release_id IS NULL
696: );
697: