APPS.PO_SUBINVENTORIES_S SQL Statements

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

Line: 60

   SELECT 'sub_valid'
   INTO   x_status
   FROM   MTL_SECONDARY_INVENTORIES
   WHERE  SECONDARY_INVENTORY_NAME = x_subinventory
   AND    ORGANIZATION_ID          = x_organization_id
   AND    NVL(DISABLE_DATE, x_transaction_date+1) > x_transaction_date;

Line: 84

   SELECT RESTRICT_SUBINVENTORIES_CODE
   INTO   x_restrict_sub
   FROM   MTL_SYSTEM_ITEMS
   WHERE  INVENTORY_ITEM_ID = x_item_id
   AND    ORGANIZATION_ID   = x_organization_id;

Line: 101

      SELECT 'sub_ok'
      INTO   x_status
      FROM   MTL_ITEM_SUB_INVENTORIES
      WHERE  INVENTORY_ITEM_ID   = x_item_id
      AND    SECONDARY_INVENTORY = x_subinventory
      AND    ORGANIZATION_ID     = x_organization_id;

Line: 167

      SELECT 'pre_loc_ok'
      INTO   x_status
      FROM   MTL_ITEM_LOCATIONS
      WHERE  INVENTORY_LOCATION_ID = x_locator
      AND    ORGANIZATION_ID = x_organization_id
      AND    NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE;

Line: 180

      SELECT RESTRICT_LOCATORS_CODE
      INTO   x_restrict_loc
      FROM   MTL_SYSTEM_ITEMS
      WHERE  INVENTORY_ITEM_ID = x_item_id
      AND    ORGANIZATION_ID   = x_organization_id;

Line: 192

         SELECT 'restrict_ok'
         INTO   x_status
         FROM   MTL_SECONDARY_LOCATORS
         WHERE  INVENTORY_ITEM_ID = x_item_id
         AND    ORGANIZATION_ID   = x_organization_id
         AND    SECONDARY_LOCATOR = x_locator;

Line: 284

   SELECT stock_locator_control_code
   INTO   x_locator
   FROM   mtl_parameters
   WHERE  organization_id = x_organization_id;

Line: 292

      SELECT locator_type
      INTO   x_locator
      FROM   mtl_secondary_inventories
      WHERE  organization_id          = x_organization_id
      AND    secondary_inventory_name = x_subinventory;

Line: 308

      SELECT restrict_locators_code, location_control_code
      INTO   x_restrict_locator, x_locator
      FROM   mtl_system_items
      WHERE  organization_id   = x_organization_id
      AND    inventory_item_id = x_item_id;

Line: 361

   SELECT stock_locator_control_code
   INTO   x_locator
   FROM   mtl_parameters
   WHERE  organization_id = x_organization_id;

Line: 369

      SELECT locator_type
      INTO   x_locator
      FROM   mtl_secondary_inventories
      WHERE  organization_id          = x_organization_id
      AND    secondary_inventory_name = x_subinventory;

Line: 380

      SELECT location_control_code
      INTO   x_locator
      FROM   mtl_system_items
      WHERE  organization_id   = x_organization_id
      AND    inventory_item_id = x_item_id;

Line: 421

     the SELECT statement only when x_subinventory is NULL.
     The local variables are superfluous after adding the IF condition.
     Removed the local variables introduced as part of earlier fix as
     it is not required.
  */

   X_progress := '010';

Line: 433

    SELECT  mis.subinventory_code
    INTO    x_subinventory
    FROM    mtl_item_sub_defaults mis,
            mtl_secondary_inventories msi
    WHERE   mis.inventory_item_id = x_item_id
    AND     mis.organization_id = x_organization_id
    AND     mis.default_type = 2
    AND     mis.organization_id = msi.organization_id
    AND     mis.subinventory_code = msi.secondary_inventory_name
    AND     trunc(NVL(msi.disable_date, trunc(sysdate+1))) > trunc(sysdate);

Line: 477

   SELECT mld.locator_id
   INTO   X_locator_id
   FROM   mtl_item_loc_defaults mld,
          mtl_item_locations mil
   WHERE  mld.inventory_item_id = X_item_id
   AND    mld.organization_id = X_organization_id
   AND    mld.subinventory_code = X_subinventory
   AND    mld.default_type = 2
   AND    mld.organization_id = mil.organization_id
   AND    mld.locator_id = mil.inventory_location_id
   AND    trunc(NVL(mil.disable_date, trunc(sysdate+1))) > trunc(sysdate);

Line: 527

     SELECT inventory_asset_flag
     INTO   x_asset_flag
     FROM   mtl_system_items
     WHERE  organization_id    = x_destination_organization_id
     AND    inventory_item_id  = x_item_id;

Line: 553

     SELECT intransit_type
     INTO   x_intransit_type
     FROM   mtl_interorg_parameters
     WHERE  from_organization_id = x_source_organization_id
     AND    to_organization_id   = x_destination_organization_id
     AND    x_source_organization_id <> x_destination_organization_id;

Line: 578

     SELECT subinventory_code
     INTO   x_dest_sub_name
     FROM   mtl_item_sub_defaults
     WHERE  inventory_item_id = x_item_id
     AND    organization_id   = x_destination_organization_id
     AND    default_type = 2;

Line: 598

     SELECT asset_inventory
     INTO   x_sub_type
     FROM   mtl_secondary_inventories
     WHERE  organization_id = x_destination_organization_id
     AND    secondary_inventory_name = x_dest_sub_name;

Line: 709

    SELECT count(1)
    INTO   x_count
    FROM   mtl_secondary_inventories  msub
    WHERE  msub.organization_id = x_src_org_id
    AND    msub.secondary_inventory_name = x_src_sub
    AND    trunc(sysdate) < nvl(disable_date, trunc(sysdate + 1))
    AND    msub.quantity_tracked = 1;

Line: 730

   SELECT msi.restrict_subinventories_code
   INTO   x_restrict_sub
   FROM   mtl_system_items msi
   WHERE  msi.inventory_item_id = x_item_id
   AND    organization_id   = x_src_org_id;

Line: 741

      SELECT count(1)
      INTO   x_count
      FROM   mtl_item_sub_inventories mis
      WHERE  mis.inventory_item_id   = x_item_id
      AND    mis.secondary_inventory = x_src_sub
      AND    mis.organization_id     = x_src_org_id;

Line: 776

    SELECT mip.intransit_type
    INTO   x_intransit_type
    FROM   mtl_interorg_parameters mip
    WHERE  mip.from_organization_id = x_src_org_id
    AND    mip.to_organization_id  = x_dest_org_id;

Line: 786

     SELECT count(1)
     INTO   x_count
     FROM   mtl_secondary_inventories msi
     WHERE  msi.secondary_inventory_name = x_src_sub
     AND    msi.asset_inventory = 2;

Line: 816

     SELECT count(1)
     INTO   x_count
     FROM   mtl_secondary_inventories msi
     WHERE  msi.secondary_inventory_name = x_src_sub
     AND    msi.asset_inventory = 2;

Line: 911

     SELECT msi.asset_inventory
     INTO   x_asset_inventory
     FROM   mtl_secondary_inventories msi
     WHERE  msi.organization_id = x_organization_id
     AND    msi.secondary_inventory_name = x_subinventory;