APPS.INV_THIRD_PARTY_STOCK_UTIL SQL Statements

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

Line: 55

   SELECT
     NVL(org_id,-99)
   INTO
      l_org_id
   FROM
      po_vendor_sites_all
   WHERE vendor_site_id = p_vendor_site_id;

Line: 125

  SELECT
    primary_unit_of_measure
  INTO
    l_uom
  FROM
    mtl_system_items
  WHERE  inventory_item_id  = p_inventory_item_id
  AND    organization_id    = p_organization_id;

Line: 156

  SELECT
    uom_code
  INTO
    l_uom_code
  FROM
    mtl_units_of_measure
  WHERE  unit_of_measure  = p_unit_of_measure;

Line: 192

  SELECT
    location_id
  INTO
    l_location_id
  FROM
    hr_all_organization_units
  WHERE  organization_id = p_organization_id;

Line: 203

      SELECT    haou.location_id
      INTO      l_location_id
      FROM      hr_all_organization_units haou,
		hr_operating_units hou
      WHERE     haou.organization_id = hou.organization_id;

Line: 230

  SELECT
    pov.vendor_name
  , povs.vendor_site_code
  INTO
    x_vendor_name
  , x_vendor_site_code
  FROM
    po_vendors pov
  , po_vendor_sites_all povs
  WHERE pov.vendor_id       = povs.vendor_id
    AND povs.vendor_site_id = p_vendor_site_id;