APPS.GMI_UPDATE_ORDER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

SELECT dg.delivery_id , st.transaction_header_id
     FROM   wsh_delivery_legs dg,
         wsh_new_deliveries dl,
         wsh_trip_stops st
     WHERE     st.stop_id = dg.pick_up_stop_id AND
         st.stop_id = p_stop_id AND
         st.stop_location_id = dl.initial_pickup_location_id AND
         dg.delivery_id = dl.delivery_id  ;

Line: 54

   SELECT   dd.delivery_detail_id, dd.source_line_id
   FROM     wsh_delivery_details dd, wsh_delivery_assignments da
   WHERE    dd.delivery_detail_id             = da.delivery_detail_id
   AND      da.delivery_id                    = l_delivery_id
   AND      NVL(dd.inv_interfaced_flag , 'N') = 'Y'
   AND      dd.container_flag                 = 'N'
   AND      dd.source_code                    = 'OE'
   AND  NOT EXISTS(select 1
                   from   rcv_shipment_lines rsl, oe_order_lines_all oel
                   where  oel.line_id             = dd.source_line_id
                   and    rsl.requisition_line_id = oel.source_document_line_id
                   and    rsl.comments            = 'OPM WDD:'||to_char(dd.delivery_detail_id));

Line: 70

SELECT source_document_type_id
     , source_document_id
     , source_document_line_id
     , ship_from_org_id
from     oe_order_lines_all
where  line_id = c_order_line_id;

Line: 82

SELECT * from wsh_delivery_details
where delivery_detail_id = p_del_detail_id
and container_flag = 'N';

Line: 92

   SELECT * FROM WSH_TRIP_STOPS
   WHERE STOP_ID = c_trip_stop_id;

Line: 140

               select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;

Line: 237

END GMI_UPDATE_ORDER;