APPS.OE_LINE_STATUS_PUB SQL Statements

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

Line: 31

SELECT cancelled_flag
INTO l_cancel_flag
FROM oe_order_lines_all
WHERE line_id = p_line_id;

Line: 82

     SELECT wias.end_date
     INTO x_result_date
     FROM wf_item_activity_statuses wias,
          wf_process_activities wpa
     WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
     AND wias.item_key = to_char(p_line_id)
     AND wias.process_activity = wpa.instance_id
     AND wpa.activity_name = 'CLOSE_LINE';

Line: 130

SELECT nvl(open_flag, 'Y')
INTO l_open_flag
FROM oe_order_lines_all
WHERE line_id = p_line_id;

Line: 181

	SELECT wias.end_date
	INTO x_result_date
	FROM wf_item_activity_statuses wias,
          wf_process_activities wpa
	WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
	AND wias.item_key = to_char(p_line_id)
     AND wias.process_activity = wpa.instance_id
     AND wpa.activity_name = 'CLOSE_LINE';

Line: 269

SELECT nvl(wias.activity_result_code, 'N'), wias.end_date
INTO x_result, x_result_date
FROM wf_item_activity_statuses wias,
     wf_process_activities wpa
WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
AND wias.item_key = to_char(p_line_id)
AND wias.process_activity = wpa.instance_id
AND wpa.activity_name = 'PUR_REL_THE_LINE';

Line: 329

	SELECT nvl(shipped_quantity, 0)
	INTO l_shipped_quantity
	FROM oe_order_lines_all
	WHERE line_id = p_line_id;

Line: 393

	SELECT nvl(shipped_quantity, 0),actual_shipment_date
	INTO l_shipped_quantity,x_result_date
	FROM oe_order_lines_all
	WHERE line_id = p_line_id;

Line: 492

	SELECT	PICK_STATUS, REQUESTED_QUANTITY, REQUESTED_QUANTITY_UOM
	FROM		WSH_DELIVERY_LINE_STATUS_V
	WHERE	SOURCE_CODE = 'OE'
	AND		SOURCE_LINE_ID = p_line_id;

Line: 581

	SELECT nvl(shipped_quantity, 0)
	INTO l_received_quantity
	FROM oe_order_lines_all
	WHERE line_id = p_line_id;

Line: 633

     SELECT wias.end_date
     INTO x_result_date
     FROM wf_item_activity_statuses wias,
          wf_process_activities wpa
     WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
     AND wias.item_key = to_char(p_line_id)
     AND wias.process_activity = wpa.instance_id
     AND wpa.activity_name = 'RMA_WAIT_FOR_RECEIVING';

Line: 680

SELECT invoice_interface_status_code
INTO l_invoice_interface_status
FROM oe_order_lines_all
WHERE line_id = p_line_id;

Line: 733

     SELECT wias.end_date
     INTO x_result_date
     FROM wf_item_activity_statuses wias,
          wf_process_activities wpa
     WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
     AND wias.item_key = to_char(p_line_id)
     AND wias.process_activity = wpa.instance_id
     AND wpa.activity_name = 'INVOICE_INTERFACE';

Line: 745

      SELECT header_id
      INTO l_header_id
      FROM oe_order_lines_all
      WHERE line_id = p_line_id;

Line: 750

      SELECT wias.end_date
      INTO x_result_date
      FROM wf_item_activity_statuses wias,
           wf_process_activities wpa
      WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
        AND wias.item_key = l_header_id
        AND wias.process_activity = wpa.instance_id
        AND wpa.activity_name = 'HEADER_INVOICE_INTERFACE';

Line: 797

       SELECT  flow_status_code
         INTO  l_flow_status_code
         FROM  oe_order_lines
        WHERE  line_id=p_line_id;

Line: 812

            SELECT meaning
            INTO l_flow_meaning
            FROM fnd_lookup_values lv
            WHERE lookup_type = 'LINE_FLOW_STATUS'
            AND lookup_code = l_flow_status_code
            AND LANGUAGE = userenv('LANG')
            AND VIEW_APPLICATION_ID = 660
            AND SECURITY_GROUP_ID =
                fnd_global.Lookup_Security_Group(lv.lookup_type,
                                                 lv.view_application_id);

Line: 829

            SELECT sum(decode(released_status, 'Y', 1, 'C', 1, 0)), sum(1)
            -- fix for 3696124 ends
            INTO released_count, total_count
            FROM wsh_delivery_details
            WHERE source_line_id   =  p_line_id
            AND   source_code      = 'OE'
            AND   released_status  <> 'D';

Line: 838

             SELECT meaning
             INTO l_flow_meaning
             FROM fnd_lookup_values lv
             WHERE lookup_type = 'LINE_FLOW_STATUS'
             AND lookup_code = 'PICKED'
             AND LANGUAGE = userenv('LANG')
             AND VIEW_APPLICATION_ID = 660
             AND SECURITY_GROUP_ID =
                  fnd_global.Lookup_Security_Group(lv.lookup_type,
                                                   lv.view_application_id);

Line: 850

             SELECT meaning
             INTO l_flow_meaning
             FROM fnd_lookup_values lv
             WHERE lookup_type = 'LINE_FLOW_STATUS'
             AND lookup_code = 'PICKED_PARTIAL'
             AND LANGUAGE = userenv('LANG')
             AND VIEW_APPLICATION_ID = 660
             AND SECURITY_GROUP_ID =
                  fnd_global.Lookup_Security_Group(lv.lookup_type,
                                                   lv.view_application_id);

Line: 861

             SELECT meaning
             INTO l_flow_meaning
             FROM fnd_lookup_values lv
             WHERE lookup_type = 'LINE_FLOW_STATUS'
             AND lookup_code = l_flow_status_code
             AND LANGUAGE = userenv('LANG')
             AND VIEW_APPLICATION_ID = 660
             AND SECURITY_GROUP_ID =
                  fnd_global.Lookup_Security_Group(lv.lookup_type,
                                                   lv.view_application_id);