APPS.GMD_COMMON_GRP SQL Statements

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

Line: 65

       SELECT Locator_type
       FROM   mtl_secondary_inventories
       WHERE  secondary_inventory_name = subinventory
         AND  organization_id          = p_organization_id;

Line: 71

       SELECT location_control_code
       FROM   mtl_system_items_b_kfv
       WHERE  organization_id     = p_organization_id
         AND  inventory_item_id   = item_id;

Line: 77

       SELECT stock_locator_control_code
       FROM   mtl_parameters
       WHERE  organization_id    = p_organization_id ;

Line: 164

        SELECT plant_ind, lab_ind
        FROM gmd_parameters_hdr
        WHERE organization_id = P_organization_id;

Line: 203

         SELECT status_id,
                grade_code
         FROM mtl_lot_numbers
         WHERE  inventory_item_id  =  p_inventory_item_id
           AND  organization_id    =  p_organization_id
           AND  ((p_lot_number IS NULL) OR (lot_number  =  p_lot_number))
           AND  ((parent_lot_number  =  p_parent_lot_number)
               OR (parent_lot_number IS NULL)
               OR (p_parent_lot_number IS NULL));

Line: 225

        SELECT status_code into x_lot_status_code
        FROM   mtl_material_statuses
        WHERE  status_id = p_lot_status_id;