APPS.OE_ORDER_MISC_PUB SQL Statements

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

Line: 22

  SELECT Line_Number,
	 Shipment_Number,
	 Option_Number,
	 Component_Number,
	 Service_Number
  INTO  p_Line_Number,
	p_Shipment_Number,
	p_Option_Number,
	p_Component_Number,
	p_Service_Number
  FROM oe_order_lines_all
  WHERE line_id=p_line_id;

Line: 119

  SELECT Line_Number,
	 Shipment_Number,
	 Option_Number,
	 Component_Number,
	 Service_Number
  INTO  p_Line_Number,
	p_Shipment_Number,
	p_Option_Number,
	p_Component_Number,
	p_Service_Number
  FROM OE_ORDER_LINES_HISTORY
  WHERE line_id=p_line_id
  AND version_number=p_version_number;

Line: 216

  SELECT distinct Line_Number,
	 Shipment_Number,
	 Option_Number,
	 Component_Number,
	 Service_Number
  INTO  p_Line_Number,
	p_Shipment_Number,
	p_Option_Number,
	p_Component_Number,
	p_Service_Number
  FROM OE_ORDER_LINES_HISTORY
  WHERE line_id=p_line_id;