APPS.WIP_AUTOSERIALPROC_PRIV SQL Statements

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

Line: 15

    SELECT msn.lot_number lot,
           count(msn.lot_number) lot_qty
      FROM mtl_object_genealogy mog,
           mtl_material_transactions mmt,
           mtl_serial_numbers msn
     WHERE mog.object_id = msn.gen_object_id
       AND msn.last_transaction_id = mmt.transaction_id
       AND mog.end_date_active IS NULL
       AND mog.parent_object_id = p_parentObjID
       AND msn.inventory_item_id = p_componentID
       AND msn.current_organization_id = p_orgID
       AND mmt.operation_seq_num = p_opSeqNum
       AND msn.lot_number IS NOT NULL
  GROUP BY msn.lot_number;

Line: 36

    SELECT msn.parent_serial_number parent_serial,
           msn.serial_number serial
      FROM mtl_object_genealogy mog,
           mtl_material_transactions mmt,
           mtl_serial_numbers msn
     WHERE mog.object_id = msn.gen_object_id
       AND msn.last_transaction_id = mmt.transaction_id
       AND mog.end_date_active IS NULL
       AND mog.parent_object_id = p_parentObjID
       AND msn.inventory_item_id = p_componentID
       AND msn.current_organization_id = p_orgID
       AND mmt.operation_seq_num = p_opSeqNum
       AND ((p_lotNumber IS NULL AND msn.lot_number IS NULL)
            OR
            (p_lotNumber IS NOT NULL AND msn.lot_number = p_lotNumber))
  ORDER BY msn.serial_number;

Line: 221

    SELECT mmt.revision revision
      FROM mtl_object_genealogy mog,
           mtl_material_transactions mmt,
           mtl_serial_numbers msn
     WHERE mog.object_id = msn.gen_object_id
       AND msn.last_transaction_id = mmt.transaction_id
       AND mog.end_date_active IS NULL
       AND mog.parent_object_id = p_parentObjID
       AND msn.inventory_item_id = p_item.inventory_item_id
       AND msn.current_organization_id = p_orgID
       AND mmt.operation_seq_num = p_item.operation_seq_num;