APPS.OZF_RESALE_PUB SQL Statements

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

Line: 48

  SELECT org_id
  FROM ozf_resale_batches_all
  WHERE resale_batch_id = cv_resale_batch_id;

Line: 183

  SELECT org_id
  FROM ozf_resale_batches_all
  WHERE resale_batch_id = cv_resale_batch_id;

Line: 423

SELECT 1
FROM ozf_resale_adjustments
WHERE resale_line_id = p_line_id
AND list_header_id = p_list_header_id
AND list_line_id IN
( (SELECT from_list_line_id
FROM   ozf_offer_adj_rltd_lines
START WITH to_list_line_id = p_list_line_id
CONNECT BY PRIOR from_list_line_id = to_list_line_id), p_list_line_id );

Line: 518

   SELECT resale_batch_id
         ,currency_code
	 ,org_id
    FROM  ozf_resale_batches_all
   WHERE  resale_batch_id = cv_resale_batch_id
     AND  status_code     = 'CLOSED';

Line: 527

   SELECT orl.resale_line_id
         ,orl.resale_header_id
	 ,orl.bill_to_cust_account_id
	 ,orl.bill_to_party_id
	 ,orl.bill_to_party_site_id
	 ,orl.bill_to_site_use_id
	 ,orl.ship_to_site_use_id
	 ,orl.sold_from_cust_account_id
	 ,orl.inventory_item_Id
	 ,orl.quantity
	 ,orl.uom_code
	 ,orl.currency_code
	 ,orl.selling_price
	 ,orl.date_ordered
	 ,orl.date_shipped
	 ,orl.date_invoiced
	 ,orl.product_transfer_movement_type
	 ,orl.last_updated_by
	 ,orl.org_id
	 ,orl.supplier_item_cost
  FROM ozf_resale_lines_all orl,
       ozf_resale_batches_all orb,
       ozf_resale_batch_line_maps_all orblm
 WHERE orblm.resale_batch_id = orb.resale_batch_id
   AND orblm.resale_line_id  = orl.resale_line_id
   AND orb.resale_batch_id   =  cv_resale_batch_id
   AND orl.resale_line_id    = cv_resale_line_id;

Line: 558

   SELECT off.offer_type,
          off.custom_setup_id,
	  off.transaction_currency_code,
	  qp.orig_org_id,
          qp.description,
	  off.status_code
    FROM ozf_offers off,
         qp_list_headers_all qp
   WHERE off.qp_list_header_id = qp.list_header_id
     AND off.qp_list_header_id = cv_qp_list_header_id;

Line: 571

   SELECT list_line_id,
          arithmetic_operator
    FROM qp_list_lines
   WHERE list_header_id = cv_list_header_id
     AND list_line_id   = cv_list_line_id;

Line: 578

  SELECT request_header_id
  FROM   ozf_sd_request_headers_all_b
  WHERE  offer_id =p_list_header_id;

Line: 583

         SELECT NVL(qpll.price_by_formula_id, qpll.operand),
                qpll.arithmetic_operator
           FROM qp_list_lines qpll
          WHERE qpll.list_line_id = p_list_line_id;

Line: 589

   SELECT user_id
   FROM fnd_user
   WHERE user_id = cv_user_id;

Line: 595

   SELECT 1
   FROM ozf_resale_adjustments
   WHERE resale_line_id = p_resale_util_rec.resale_line_id
     AND list_header_id = p_resale_util_rec.list_header_id
     AND list_line_id IN ((SELECT from_list_line_id
                             FROM ozf_offer_adj_rltd_lines
                             START WITH to_list_line_id = p_resale_util_rec.list_line_id
                             CONNECT BY PRIOR from_list_line_id = to_list_line_id), p_resale_util_rec.list_line_id );

Line: 888

     l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_line_rec.last_updated_by);