APPS.OE_FULFILL_WF SQL Statements

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

Line: 47

          SELECT item_type_code,shippable_flag,top_model_line_id, service_reference_type_code
          INTO   l_item_type,l_shippable_flag,l_top_model_line_id, l_service_reference_type_code
          FROM   oe_order_lines_all
          WHERE  line_id = to_number(itemkey);

Line: 69

              SELECT header_id,service_reference_line_id
              INTO   l_header_id,l_service_ref_line_id
              FROM   oe_order_lines_all
              WHERE  line_id = to_number(itemkey)
              AND    service_reference_type_code = 'ORDER';

Line: 76

              SELECT header_id,shippable_flag
              INTO   l_service_header_id,l_service_ship_flag
              FROM   oe_order_lines_all
              WHERE  line_id = l_service_ref_line_id;

Line: 218

       SELECT WIAS.Activity_Status
       INTO   l_activity_status
       FROM   wf_item_activity_statuses WIAS,
              wf_process_activities WPA
       WHERE  WIAS.Process_Activity = WPA.instance_id
       AND    WPA.activity_name     = 'FULFILL_LINE_ELIGIBLE'
       AND    WIAS.item_type        = 'OEOL'
       AND    WIAS.item_key         = to_char(p_line_id)
       AND    WIAS.activity_status  = 'NOTIFIED' ;

Line: 346

        SELECT header_id
              ,order_source_id
              ,orig_sys_document_ref
              ,orig_sys_line_ref
              ,orig_sys_shipment_ref
              ,change_sequence
              ,source_document_type_id
              ,source_document_id
              ,source_document_line_id
         INTO l_header_id
              ,l_order_source_id
              ,l_orig_sys_document_ref
              ,l_orig_sys_line_ref
              ,l_orig_sys_shipment_ref
              ,l_change_sequence
              ,l_source_document_type_id
              ,l_source_document_id
              ,l_source_document_line_id
        FROM  oe_order_lines_all
       WHERE  line_id = l_line_id;