APPS.INV_MGD_MVT_UTILS_PKG SQL Statements

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

Line: 368

    SELECT
      conversion_rate
    INTO
      l_rate
    FROM
      mtl_uom_conversions
    WHERE uom_code = p_uom_code
      AND inventory_item_id = p_item_id;

Line: 385

    SELECT
      conversion_rate
    INTO
      l_rate
    FROM
      mtl_uom_conversions
    WHERE uom_code = p_uom_code
      AND inventory_item_id = 0;

Line: 511

    SELECT uom_class
      INTO l_tranx_uom_class
      FROM mtl_units_of_measure_vl
     WHERE uom_code = p_tranx_uom_code;

Line: 517

    SELECT uom_class
      INTO l_stat_typ_uom_class
      FROM mtl_units_of_measure_vl
     WHERE uom_code = p_stat_typ_uom_code;

Line: 560

      SELECT
        unit_weight
      , weight_uom_code
      , primary_uom_code
      INTO
        l_item_unit_weight
      , l_weight_uom_code
      , l_primary_uom_code
      FROM
        MTL_SYSTEM_ITEMS muc
      WHERE muc.inventory_item_id   = p_inventory_item_id
        AND   muc.organization_id     = p_organization_id;

Line: 818

  SELECT attribute_code INTO l_alt_uom_code
  FROM   MTL_MVT_STATS_RULES R
       , MTL_MVT_STATS_RULE_SETS_B RS
  WHERE  R.rule_set_code    = RS.rule_set_code
  AND    R.COMMODITY_CODE   = p_commodity_code
  AND    RS.category_set_id = p_category_set_id
  AND    RS.rule_set_type    = 'ALTERNATE_UOM'
  AND    R.rule_set_code    = p_alt_uom_rule_set_code;

Line: 877

  SELECT
    fnd.eu_code
  FROM
    FND_TERRITORIES fnd
  WHERE
  territory_code = l_iso_code;

Line: 945

SELECT
  sic.category_id
FROM
    MTL_SYSTEM_ITEMS si
  , MTL_ITEM_CATEGORIES sic
WHERE si.inventory_item_id    = sic.inventory_item_id
  AND si.organization_id      = sic.organization_id
  AND si.inventory_item_id    = p_movement_Transaction.inventory_item_id
  AND si.organization_id      = p_movement_Transaction.organization_id
  AND sic.category_set_id     = p_stat_typ_transaction.category_set_id;

Line: 1042

SELECT
  substrb(mkv.concatenated_segments,1,230)
, substrb(mic.description,1,230)
FROM
  MTL_CATEGORIES mic
, MTL_CATEGORIES_KFV mkv
WHERE  mic.category_id  = mkv.category_id
AND    mic.category_id  = x_movement_transaction.category_id;

Line: 1116

SELECT
  oh.order_number
, oh.org_id
FROM
  OE_ORDER_HEADERS_ALL oh
WHERE   oh.header_id  = x_movement_transaction.order_header_id;

Line: 1187

  SELECT
    hzl.country
  FROM
    HZ_CUST_ACCT_SITES_ALL ras
  , HZ_CUST_SITE_USES_ALL raa
  , HZ_LOCATIONS hzl
  , HZ_PARTY_SITES hzp
  WHERE ras.cust_acct_site_id  = raa.cust_acct_site_id
  AND   NVL(ras.org_id, -1)    = NVL(raa.org_id, -1)     --fix bug 4015171
  AND   ras.party_site_id      = hzp.party_site_id
  AND   hzl.location_id        = hzp.location_id
  AND   raa.site_use_id        = p_site_use_id;

Line: 1203

  SELECT
    DISTINCT territory_code
  FROM
    FND_TERRITORIES_TL        --fix bug 4165090
  WHERE
    territory_short_name = l_short_name;

Line: 1276

  SELECT
    hrl.country
  FROM
    HR_ALL_ORGANIZATION_UNITS hr
  , HR_LOCATIONS_ALL hrl
  WHERE hr.location_id     = hrl.location_id
  AND   hr.organization_id = p_warehouse_id;

Line: 1286

  SELECT
    DISTINCT territory_code
  FROM
    FND_TERRITORIES_TL                      --fix bug 4165090
  WHERE
    territory_short_name = l_short_name;

Line: 1360

  SELECT
    hrl.country
  FROM
    mtl_secondary_inventories msi
  , HR_LOCATIONS_ALL hrl
  WHERE hrl.location_id     = msi.location_id
  AND   msi.organization_id = p_warehouse_id
  AND   msi.secondary_inventory_name = p_subinv_code;

Line: 1371

  SELECT
    DISTINCT territory_code
  FROM
    FND_TERRITORIES_TL                           --fix bug 4165090
  WHERE
    territory_short_name = l_short_name;

Line: 1448

  SELECT
    pov.country
  FROM
    PO_VENDOR_SITES_ALL pov
  WHERE pov.vendor_site_id  = p_vendor_site_id;

Line: 1517

  SELECT
    zone_code
  FROM
    MTL_COUNTRY_ASSIGNMENTS
  WHERE territory_code = p_territory_code
  AND   zone_code      = p_zone_code
  AND   p_trans_date  BETWEEN (start_date) and (NVL(end_date,p_trans_date));

Line: 1587

SELECT
  pov.vendor_name
, pov.segment1
, povs.vendor_site_code
, povs.province
, povs.vat_registration_num
FROM
  PO_VENDORS pov
, PO_VENDOR_SITES_ALL povs
WHERE  pov.vendor_id       = povs.vendor_id
AND    pov.vendor_id       = x_movement_transaction.vendor_id
AND    povs.vendor_site_id = x_movement_transaction.vendor_site_id;

Line: 1651

  SELECT
    raa.tax_reference
  FROM
    HZ_CUST_SITE_USES_ALL raa
  WHERE   raa.site_use_id        = p_site_use_id;

Line: 1786

SELECT
  sold_to_org_id
, org_id
FROM
  oe_order_lines_all
WHERE line_id = p_order_line_id;

Line: 1809

   SELECT To_Number(NVL(O3.ORG_INFORMATION2,-1))
      INTO l_so_le_id
      FROM HR_ALL_ORGANIZATION_UNITS O
         , HR_ORGANIZATION_INFORMATION O2
         , HR_ORGANIZATION_INFORMATION O3
      WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
      AND   O.ORGANIZATION_ID = O3.ORGANIZATION_ID
      AND   O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
      AND   O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
      AND   O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
      AND   O2.ORG_INFORMATION2 = 'Y'
      AND   O.ORGANIZATION_ID = l_so_ou_id;

Line: 1876

SELECT
  TO_NUMBER(org_information2)
FROM
  hr_organization_information
WHERE org_information_context = 'Accounting Information'
  AND organization_id = p_warehouse_id;

Line: 1945

SELECT
  currency_code
FROM
  gl_ledger_le_v
WHERE legal_entity_id = p_le_id
  AND ledger_category_code = 'PRIMARY';

Line: 2015

SELECT
  country
FROM
  xle_firstparty_information_v
WHERE legal_entity_id = p_le_id;

Line: 2023

  SELECT
    DISTINCT territory_code
  FROM
    FND_TERRITORIES_TL                      --fix bug 4165090
  WHERE
    territory_short_name = l_short_name;

Line: 2105

SELECT
  weight_precision
, reporting_rounding
FROM
  mtl_stat_type_usages
WHERE legal_entity_id = p_legal_entity_id
  AND zone_code       = p_zone_code
  AND usage_type      = p_usage_type
  AND stat_type       = p_stat_type;

Line: 2184

    SELECT CEIL(p_number * POWER(10,p_precision))/POWER(10,p_precision)
    INTO l_number
    FROM dual;

Line: 2226

SELECT
  organization_id
FROM hr_organization_information
WHERE org_information_context = 'Accounting Information'
  --AND to_number(org_information2) = p_le_id
  AND org_information2 = to_char(p_le_id)
  AND rownum = 1;

Line: 2337

     SELECT NVL(process_enabled_flag, 'N')
     FROM   mtl_parameters
     WHERE  organization_id = p_org_id;