APPS.CHV_INQ_SV SQL Statements

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

Line: 29

  select rct.transaction_date,
         rsh.shipment_num,
         rsl.quantity_received,
         rsl.unit_of_measure
    into x_transaction_date,
         x_shipment_number,
         x_quantity_received,
         x_receiving_unit_of_measure
  from rcv_transactions rct,
       rcv_shipment_headers rsh,
       rcv_shipment_lines rsl
  where transaction_id = p_last_receipt_transaction_id
  and  rct.shipment_header_id = rsh.shipment_header_id
  and  rct.shipment_line_id   = rsl.shipment_line_id ;

Line: 51

select sum(quantity_received)
into x_quantity_received
from rcv_shipment_lines rsl
where rsl.shipment_header_id=(select rct.shipment_header_id
                              from rcv_transactions rct where
                              transaction_id = p_last_receipt_transaction_id)
and rsl.item_id = p_item_id;

Line: 61

  select uom_code
    into x_receiving_uom_code
    FROM mtl_units_of_measure
   WHERE unit_of_measure = X_receiving_unit_of_measure ;

Line: 66

  select uom_code
    into x_purchasing_uom_code
    FROM mtl_units_of_measure
   WHERE unit_of_measure = p_purchasing_unit_of_measure ;

Line: 103

  SELECT *
    INTO bucket_rec
    FROM chv_horizontal_schedules
   WHERE schedule_id = p_schedule_id
     AND schedule_item_id = p_schedule_item_id
     AND row_select_order = 1 ;

Line: 110

  SELECT *
    INTO start_date_rec
    FROM chv_horiz_date_schedules_v
   WHERE schedule_id = p_schedule_id
     AND schedule_item_id = p_schedule_item_id
     AND row_select_order = 2 ;

Line: 117

  SELECT *
    INTO end_date_rec
    FROM chv_horiz_date_schedules_v
   WHERE schedule_id = p_schedule_id
     AND schedule_item_id = p_schedule_item_id
     AND row_select_order = 7 ;

Line: 628

      SELECT poatt.using_organization_id
        INTO x_organization_id
	FROM  po_asl_attributes_val_v poatt
       WHERE poatt.using_organization_id = p_organization_id
	 AND poatt.vendor_id             = p_vendor_id
	 AND poatt.vendor_site_id        = p_vendor_site_id
	 AND poatt.item_id               = p_item_id;

Line: 660

 select max(rct.transaction_id)
        into x_last_receipt_id
        from   rcv_transactions rct,
	       rcv_shipment_lines rsl,
	       po_headers poh
	where  rct.shipment_line_id = rsl.shipment_line_id
	and    rct.transaction_type = 'RECEIVE'
	and    rct.transaction_date between
   		to_date(x_cum_period_start_date,'YYYY/MM/DD') and
                to_date(x_cum_period_end_date,'YYYY/MM/DD')
        and    rsl.to_organization_id = x_organization_id
        and    rsl.item_id            = x_item_id
        and    rsl.po_header_id       = poh.po_header_id
        and    poh.vendor_id          = x_vendor_id
        and    poh.vendor_site_id     = x_vendor_site_id
        and    poh.supply_agreement_flag = 'Y'
        and    rct.transaction_date in
        (select max(rct2.transaction_date)
        from   rcv_transactions rct2,
	       rcv_shipment_lines rsl2,
               po_headers poh2
        where  rct2.shipment_line_id   = rsl2.shipment_line_id
        and    rct2.transaction_type   = 'RECEIVE'
        and    rct2.transaction_date between
                to_date(x_cum_period_start_date,'YYYY/MM/DD') and
                to_date(x_cum_period_end_date,'YYYY/MM/DD')
        and    rsl2.to_organization_id = x_organization_id
        and    rsl2.item_id            = x_item_id
        and    rsl2.po_header_id       = poh.po_header_id
        and    poh2.vendor_id          = x_vendor_id
        and    poh2.vendor_site_id     = x_vendor_site_id
        and    poh2.supply_agreement_flag = 'Y');

Line: 713

 SELECT displayed_field
   INTO x_bucket_type_dsp
   FROM po_lookup_codes
  WHERE lookup_type = 'SCHEDULE_BUCKET_TYPE'
    AND lookup_code = p_bucket_type_code ;