APPS.RCV_DATES_S SQL Statements

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

Line: 119

   		Select 	whse_code,orgn_code
   		into 	x_whse_code,x_opm_orgn
   		from 	ic_whse_mst
		where 	mtl_organization_id = x_org_id;

Line: 212

      SELECT transaction_date
      INTO   x_parent_trx_date
      FROM   rcv_transactions
      WHERE  transaction_id = x_parent_trx_id;

Line: 240

      SELECT trunc(rsh.shipped_date)
      INTO   x_shipped_date
      FROM   rcv_shipment_headers rsh,
             rcv_shipment_lines   rsl
      WHERE  rsh.shipment_header_id = rsl.shipment_header_id
      AND    rsh.organization_id = x_org_id;

Line: 291

   SELECT days_early_receipt_allowed, days_late_receipt_allowed,
	  promised_date, need_by_date
   INTO   x_days_early_receipt_allowed, x_days_late_receipt_allowed,
	  x_promised_date, x_need_by_date
   FROM   po_line_locations
   WHERE  line_location_id = x_line_loc_id;