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_SO_PLN_SERVER dependencies on SO_PICKING_LINE_DETAILS

Line 121: FROM SO_PICKING_LINE_DETAILS

117: begin
118:
119: SELECT NVL(SUM ( NVL ( REQUESTED_QUANTITY , 0 ) ), 0)
120: INTO DB_Res_Qty
121: FROM SO_PICKING_LINE_DETAILS
122: WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
123: AND PICKING_LINE_ID = X_Picking_Line_Id;
124:
125: Return (DB_Res_Qty);

Line 534: FROM so_picking_line_details

530: BEGIN
531:
532: SELECT min(1)
533: INTO complexDetails
534: FROM so_picking_line_details
535: WHERE picking_line_id = x_picking_line_id
536: AND NVL( released_flag, 'N') = 'N'
537: HAVING COUNT( DISTINCT warehouse_id) > 1
538: OR COUNT( DISTINCT schedule_date) > 1