APPS.PO_LINE_TYPES_SV SQL Statements

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

Line: 21

  SELECT line_type_id
  INTO   X_line_type_id_v
  FROM   po_line_types
  WHERE  sysdate < nvl(inactive_date, sysdate + 1)
  AND    line_type_id = X_line_type_id;

Line: 132

	SELECT 	lt.order_type_lookup_code,
            lt.purchase_basis,                                -- 
            lt.matching_basis,                                -- 
                lt.category_id,
            	lt.unit_of_measure,
            	lt.unit_price,
		nvl(lt.outside_operation_flag,'N'),
            	lt.receiving_flag,
                lt.receive_close_tolerance
	FROM   	po_line_types_b   lt                              -- 
     	WHERE  	lt.line_type_id = p_line_type_id;             -- 

Line: 364

  SELECT polt.line_type
  INTO   x_line_type
  FROM   po_line_types polt
  WHERE  polt.line_type_id = x_line_type_id
  AND    nvl(polt.inactive_date,sysdate + 1) > sysdate;

Line: 399

    	SELECT 	item_id, org_id
    	FROM	po_lines_all
    	WHERE 	po_header_id = p_po_header_id;

Line: 453

    SELECT	outside_operation_flag
    INTO	l_outside_operation_flag
    FROM	mtl_system_items
    WHERE	inventory_item_id = p_item_id
    AND		organization_id	= p_org_id;

Line: 491

    SELECT 	outside_operation_flag
    INTO	x_outside_operation_flag
    FROM 	po_line_types
    WHERE	line_type_id = p_line_type_id;

Line: 558

	SELECT 'Lines Exist'
	into l_transactions_exist
        FROM   dual
	where  EXISTS (SELECT 'Req Lines Exist'
		  	   From po_requisition_lines_all PRL
			   WHERE  PRL.line_type_id = p_line_type_id)

                OR EXISTS (SELECT 'PO Lines Exist'
		           FROM   po_lines_all POL
		           WHERE  POL.line_type_id = p_line_type_id)

                OR EXISTS (SELECT  'Archived PO Lines Exist'
			   FROM   po_lines_archive_all POAL
		           WHERE  POAL.line_type_id = p_line_type_id ) ;